| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Ignoring dates when calculating differences in time | Excel Worksheet Functions | |||
| Calculating differences in time. PLs Help | Excel Discussion (Misc queries) | |||
| Calculating Date AND Time Differences | Excel Worksheet Functions | |||
| Calculating time differences across two (or more) dates | Excel Discussion (Misc queries) | |||
| calculating time/dates differences | Excel Discussion (Misc queries) | |||
Linear Mode
