Time Sheet - Calculating Time Differences for Totals

  • Thread starter Thread starter Kathy
  • Start date Start date
K

Kathy

I have a time sheet with four fields:
Time In (C2), Lunch Out (D2), Lunch In (E2), Time Out (F2)
I'm trying to create a formula in cell G2 to calculate the regular hours and
another formula in H2 for the overtime hours, but have been unsuccessful.
Current fields are formatted as Number | Custom | h:mm AM/PM for C2 thru F2
and are formatted as Number | Custom | h:mm for G2 and H2.

Can anyone help me.
 
This was a great help to me. The only problem I'm having now is that I want
to total the column of regular hours, but it's not coming up to the correct
total. I've tried to just use the sum function, but that's not bringing up
the right total. Any suggestions?
 
Back
Top