Sum hour

S

Samp

all would be the sum of those values in hour?

0,000694444
0,016041667
0,166875
0,002708333
0,000694444
0,000347222
1,364027778
2,09875
0,004097222
0,000416667
0,001736111
0,000694444
3,657083333


thank you advance
 
S

Samp

It appears that your post is missing some information.
--
KARL DEWEY
Build a little - Test a little





- Mostrar texto entre aspas -
Click to expand...

transform double in hour and sum()

0,000694444
0,016041667
0,166875
0,002708333
0,000694444
0,000347222
1,364027778
2,09875
0,004097222
0,000416667
0,001736111
0,000694444
 
K

KARL DEWEY

Try this ---
CVDate(Val(Replace([Hour_],",",".")))

[Hour_] is the name of the field.

Expr1
12:01:00 AM
12:23:06 AM
4:00:18 AM
12:03:54 AM
12:01:00 AM
12:00:30 AM
12/31/1899 8:44:12 AM
01/01/1900 2:22:12 AM
12:05:54 AM
12:00:36 AM
12:02:30 AM
12:01:00 AM
01/02/1900 3:46:12 PM
 
S

Samp

Try this ---
CVDate(Val(Replace([Hour_],",",".")))

[Hour_] is the name of the field.

Expr1
12:01:00 AM
12:23:06 AM
4:00:18 AM
12:03:54 AM
12:01:00 AM
12:00:30 AM
12/31/1899 8:44:12 AM
01/01/1900 2:22:12 AM
12:05:54 AM
12:00:36 AM
12:02:30 AM
12:01:00 AM
01/02/1900 3:46:12 PM
--
KARL DEWEY
Build a little - Test a little



transform those number for hour.- Ocultar texto entre aspas -
Click to expand...

- Mostrar texto entre aspas -
Click to expand...

wanted like this:

0:01:00
0:23:06
4:00:18
0:03:54
0:01:00
0:00:30
8:44:12
2:22:12
0:05:54
0:00:36
0:02:30
0:01:00

result:15:46:12
 
K

KARL DEWEY

Format(Val(Replace([Hour_],",",".")),"hh")+(Int(Val(Replace([Hour_],",",".")))*24) & ":" & Format(Val(Replace([Hour_],",",".")),"nn:ss")
Gives you ---
Hour_ Expr2
0,000694444 0:01:00
0,016041667 0:23:06
0,166875 4:00:18
0,002708333 0:03:54
0,000694444 0:01:00
0,000347222 0:00:30
1,364027778 32:44:12
2,09875 50:22:12
0,004097222 0:05:54
0,000416667 0:00:36
0,001736111 0:02:30
0,000694444 0:01:00
3,657083333 87:46:12

I'll let you add them.

--
KARL DEWEY
Build a little - Test a little


Samp said:
Try this ---
CVDate(Val(Replace([Hour_],",",".")))

[Hour_] is the name of the field.

Expr1
12:01:00 AM
12:23:06 AM
4:00:18 AM
12:03:54 AM
12:01:00 AM
12:00:30 AM
12/31/1899 8:44:12 AM
01/01/1900 2:22:12 AM
12:05:54 AM
12:00:36 AM
12:02:30 AM
12:01:00 AM
01/02/1900 3:46:12 PM
--
KARL DEWEY
Build a little - Test a little



Samp said:
On 14 nov, 15:36, KARL DEWEY <[email protected]>
wrote:
I still do not get what you are saying/asking.
Click to expand...
:
On 14 nov, 12:38, KARL DEWEY <[email protected]>
wrote:
It appears that your post is missing some information.
Click to expand...
:
all would be the sum of those values in hour?

thank you advance- Ocultar texto entre aspas -
Click to expand...
- Mostrar texto entre aspas -
Click to expand...
transform double in hour and sum()
Click to expand...
0,000694444
0,016041667
0,166875
0,002708333
0,000694444
0,000347222
1,364027778
2,09875
0,004097222
0,000416667
0,001736111
0,000694444- Ocultar texto entre aspas -
Click to expand...
- Mostrar texto entre aspas -
Click to expand...
transform those number for hour.- Ocultar texto entre aspas -
Click to expand...

- Mostrar texto entre aspas -
Click to expand...

wanted like this:

0:01:00
0:23:06
4:00:18
0:03:54
0:01:00
0:00:30
8:44:12
2:22:12
0:05:54
0:00:36
0:02:30
0:01:00

result:15:46:12
Click to expand...
 
Top