| Simple problem, need help |
 Posted by
Felicejohn Vergona
on Sunday, March 19, 2006 at 10:27:13 AM (EST)
Hello everyone,
Any help would be appreciated.
All I want to do is add up some time values (i.e. 1:20:03, 3:29:01, 1:06:06, etc)and get a total sum. So in the above example, the total would/should be=5:54:10.
However in Tab4.2 it is not...
The column I am adding up has 29 time values. The formula I am using is: =sum(H13:H41). I want the number in box H(42) to be the sum of the 29 time values.
The sum I am getting is wrong!
Can anyone answer why this is?
Thanks.
|
 Posted by
Felicejohn Vergona
on Sunday, March 19, 2006 at 11:10:16 AM (EST)
Hello Everyone, me again...
I see what is happening...Once the total amount of hours hits over 24 (as in 24 hours in a day...the counter registers "25 hours, 57 minutes, 03 seconds" as "1:57:00", but I need the culmuative hours to be displayed as "25:57:03" - so 25 hours, 57 minutes, and 03 seconds.
See my problem? I am sure it is an easy fix, but I am spending 10's of hours to figure this out. Any help, please...
Thanks.
|
Posted by
Jean Autery
on Sunday, July 30, 2006 at 4:18:37 PM (EST)
Fun question. The problem is that the counters are limited to hh:mm:ss and count absolutely up to 23:59:59 and then roll to 00:00:00. You can change the format to dd:hh:mm:ss, but "dd" is the REAL current "date" day (1-31). ie if the date is 07/30/06 and you add 00:23:59:59 to 00:00:00:01, the results would be 31:00:00:00. So, there isn't a way count "hh" over 23. If you found a way, share.
|
|
