Adding Hours worked

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to set up a calculated sheet that will add the before lunch hours with
the after lunch hours, then divide by the 24 hour clock
 
I had the same problem and this is the way I did it:
(Time out before Lunch - Time in befor lunch)*24 + (time out after lunch -
time in after lunch)*24

This will give you a total in decimal for the whole day

Hope I was helpfull

Regards
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Time Calculated minus breaks & lunch 2
Timesheet - Formula 3
Time Sheet - Calculating Time Differences for Totals 3
Calculating Time 6
Excel Formula 2
Work hours with overtime 2
Schedule hours calculation 6
Overtime Calculations 4

Back
Top