Archive of Mr Excel Message Board
Back to Forms in Excel VBA archive index
Back to archive home
summing time
Posted by Ivan Turkijevic on February 06, 2002 6:58 AM
I want to calculate my total time worked for a month. I have the time for every day in the HH:MM format in a column and i want to sum the times to see the total. I have tried to just sum it but it does not work, how do I do?
Best Regards,
Ivan T
Check out our Excel Resources



Re: summing time
Posted by Denise G on February 06, 2002 7:28 AM
I just read last night that in Excel time is interpreted as fractions of dates, where dates are numbered sequentially starting with January 01 1900 being equal to 1. 12AM on Jan 1, 1900 would then be 1.0, and 12PM would be 1.5. Time elapsed would be:
Time Elapsed = 1.51.0 = 0.5 or 12 hours.
So, try calculating the difference between dates, including the hour and minute detail, and then sum the differences.
Good luck, and let me know if it works, because I've not tried it myself.
Denise
Re: summing time
Posted by Juan Pablo G. on February 06, 2002 8:02 AM
Altough Excel does treat time as fractions of a day, it does recongize them as Time.
So, if you have this times
01:34
13:56
04:65
You can use the SUM() function to add them, and format this cell as [hh]:mm just in case the result is over 24 hours.
Juan Pablo G.
Re: summing time
Posted by Denise G on February 06, 2002 8:32 AM
Does this mean it is not necessary to calculate the elapsed time before summing with the difference formula?
Denise
Check this for the answer 18396.html
Posted by Juan Pablo G. on February 06, 2002 9:22 AM
: Altough Excel does treat time as fractions of a day, it does recongize them as Time. : So, if you have this times : 01:34
This archive is from the original message board at www.MrExcel.com.
All contents © 19982004 MrExcel.com.
Visit our
online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.