Time Sheet - Calculating Time Differences for Totals
 

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.

Time Sheet - Calculating Time Differences for Totals
 

Hi,
Look into CPearson Web it has all the working with overtime Hs

http://www.cpearson.com/excel/overtime.htm



"Kathy" wrote:

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.

Time Sheet - Calculating Time Differences for Totals
 

Thanks for the help!


"Eduardo" wrote:

Hi,
Look into CPearson Web it has all the working with overtime Hs

http://www.cpearson.com/excel/overtime.htm



"Kathy" wrote:

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.

Time Sheet - Calculating Time Differences for Totals
 

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?


"Eduardo" wrote:

Hi,
Look into CPearson Web it has all the working with overtime Hs

http://www.cpearson.com/excel/overtime.htm



"Kathy" wrote:

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.