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.5-1.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 © 1998-2004 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.