MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Calculating Time

Posted by Mike Consolo on August 08, 2001 2:40 PM

To Whomever Can Help-

I am trying to calculate the sum of hours that someone might work. I have no problem calculating the hours per day. But when I try and add the total for each of those days together it does not show as 40 or 50, etc.

For example 8 hours on Monday, 8 hours on Tuesday. I would enter 8:00 through 16:00 for each of those days. It would calculate the hours for that day as 8:00(16:00 minus 8:00). However when I add the time for each of those days (8:00 plus 8:00) it does not return the correct value(16).

Can someone tell me how I can use calculations with time.



Posted by Aladin Akyurek on August 08, 2001 2:42 PM

Custom format the cell where you do the summing as:




Posted by Mark W. on August 08, 2001 2:44 PM

Format total as... [h]:mm

Posted by Mark W. on August 08, 2001 2:50 PM

Wasted too much time spelling "Pythagorean" : )

Posted by Ian on August 08, 2001 3:34 PM

Mark and Aladin are correct of course...but in your example 8:00 + 8:00 does come out as 16 (well, 16:00)