Solved i have a problem on calculating a total OT hours

May 28, 2015 at 06:00:42
Specs: Windows 7
5:00 PM 5:00 PM 5:00 PM 5:00 PM 5:00 PM 5:00 PM 5:00 PM 5:00 PM 5:00 PM 5:00 PM 5:00 PM 5:00 PM
4:00 AM 4:00 AM 5:30 AM 4:00 AM 3:30 AM 2:00 AM 5:30 AM 3:30 AM 5:00 AM 4:00 AM 3:30 AM 6:00 AM
2:00 2:00 3:30 2:00 1:30 0:00 3:30 1:30 3:00 2:00 1:30 4:00

this is the hours, my regular working hour is 9 hours including dinner break
the 3rd column is the OT hour when i sum up to get the total hour it gives me this
6650:30 value i the format i used for this is [h]:mm and when convert it to h:mm it gives me 2:30 the sum must be 26:30 (26.5)


please help me......
to get the actual value


See More: i have a problem on calculating a total OT hours

Report •

#1
May 28, 2015 at 08:04:08
✔ Best Answer
In a fourth column (hidden if you wish), multiply the overtime hours by 24. This will convert the time to decimal.

You can now sum this new column to get total overtime hours.

See this link for more info: http://www.excelfunctions.net/Conve...

Can I put a question here?

message edited by Matt123


Report •
Related Solutions


Ask Question