| 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. |
| 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) | |||
Threaded Mode
