time usage
Posted by Vasia on September 01, 2000 10:49 AM
Help
I am trying to create a time usage.
I have one column showing start time and 2nd column with end time.
19:48:35 20:55:25 01:06:50
23:08:24 00:21:53 01:13:29
20:56:36 21:19:11 00:22:35
02:57:51 03:32:23 00:34:32
03:44:32 03:48:14 00:03:42
My problem is adding them up. I need to have a total of hours and keep getting totals like
32388:20:25
12:20:25
I've set up in format - custom
hh:mm:ss
[h]:mm:ss
what I need is to add all the time elapsed 2 ways
days hours minutes seconds
total hours minutes seconds
Any help would be appreciated.
Vasia