Calculating working hours excluding Breaks

[Bella Jeon0815]

I'd like to make a sheet to calculate working hours, using Start time & End time and Breaktime.

I've created attached sheet, however, it shows somewhat different from what I expected.
Mon. Tue Wed Thu Fri Total
Start 09:15 07:30 08:15 09:00 09:15
End 13:45 16:30 16:45 17:00 13:45
Lunch 00:30 00:30 00:30 00:30 00:00
Total Hours 04:00 08:30 08:00 07:30 04:30 1.35
Expected Answer 4.00 8.50 8.00 7.50 4.50
32.50 (this is what I want to have)




Instead of manual input, how to calculate the Net working hours ?

 

[Luke M]

You're pretty close. the cells in row 5 are currently displaying data in time format, but you want the answer in hours. We need to use the unit multiplier of 24 hrs/1 day. So, change the formula in C5 to this:
=(C3-C2-C4)*24

and change the format of the cell to be Number with 2 decimals showing. Copy to the right as needed, and you'll see the calculations are working correctly.

 

[Bella Jeon0815]

Hi Luke M Ninja,

Thanks Millions. Looks simple thing but If I don't know this trick then It became a real headache for me. !!! You solve my headache. !! Great Thanks