| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating my work hours minus lunch break and then adding forweekly total
I'm having trouble creating a time worksheet. I want to subtract my start time from my end time, determine if I have worked longer than 4 hours (company automatically takes 30 mins for a lunch break off total if you work more than 4 hours), and then calculate total house worked. I'm having a problem with the lunch break portion of the calculation. I need a formula that will work. What can I do??
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate hours worked minus a half hour for lunch | Excel Worksheet Functions | |||
| I need to calculate hours worked from 11pm to 7am minus a lunch | Excel Worksheet Functions | |||
| how to calculate hours worked daily & minus 30 min lunch, 7am-5pm | Excel Discussion (Misc queries) | |||
| How can I calculate daily hours worked minus lunch to eual a decim | Excel Worksheet Functions | |||
| Calculating total work week hours | Excel Worksheet Functions | |||
Threaded Mode
