MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Calculating work hours


Posted by John Buxton on January 03, 2001 7:03 AM

I'm trying to find out how I can Calculate hours worked.
eg:

Started Finished Hours
9.30 1.00 3.30 ( problem here is that when you add the column up it can give answers like 34.70 hours - I want to display the half hour as 30 minutes not as a percentage like .5
Your Help would be greatly appreciated.


Posted by cpod on January 03, 2001 7:50 AM

To change the decimal hours total to hours and minutes:

=TRUNC(DecimalTime) & ":" & ROUND((DecimalTime-TRUNC(DecimalTime))*60,0)

Posted by Dave on January 04, 2001 12:05 AM

Hi John

You might also be able to use =DecimalTime/24

Dave

  • OzGrid Business Applications

Posted by Dave on January 04, 2001 12:06 AM

Hi John

You might also be able to use =DecimalTime/24
and format your cell as Number>Custom>[h]:mm

Dave

  • OzGrid Business Applications