MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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


Posted by Vassili Jabin on September 05, 0100 8:49 AM

Thomas
thanks for the help. Luckily the report is not that big

Vasia

Posted by thomas venn on September 01, 0100 4:24 PM

Hello,

i copied your values and looked at it in Excel. i am unable to find any faul with the data you submitted. however, i suspect that there is a date associated with your time which you are not showing in your example. anyway, here is one way in which you may resolve your problem. in column d, use =hour(c1) Then in column e, use =minute(c1) then in column f, use =second(c1). you add up all the hours, minutes and seconds. but, remember to divide the minutes and seconds by 60. give it a try.


Cheers,

Thomas Help