Sum hour

[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

 

[Guest]

It appears that your post is missing some information.

 

[Samp]

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





- Mostrar texto entre aspas -

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

 

[Guest]

I still do not get what you are saying/asking.

 

[Samp]

I still do not get what you are saying/asking.
--
KARL DEWEY
Build a little - Test a little







- Mostrar texto entre aspas -

transform those number for hour.

 

[Guest]

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

 

[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 -

- Mostrar texto entre aspas -

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

 

[Guest]

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

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

On 14 nov, 15:36, KARL DEWEY <[email protected]>
wrote:
I still do not get what you are saying/asking.

:
On 14 nov, 12:38, KARL DEWEY <[email protected]>
wrote:
It appears that your post is missing some information.

:
all would be the sum of those values in hour?

thank you advance- Ocultar texto entre aspas -

- Mostrar texto entre aspas -

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- Ocultar texto entre aspas -

- Mostrar texto entre aspas -

transform those number for hour.- Ocultar texto entre aspas -

- Mostrar texto entre aspas -

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