| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to subtract a lunch break from total hrs worked in timesheet
I am setting up a time sheet in excel. For each day of the week, the end user
enters Time in and Time out. GA has a 30 min lunch break that I need to subtract out of the total time for the day. I would like the end user to be able to insert more that 30 mins if necessary. I've checked the templates on the MS web, but none subtract a time. Thanks, Zoe Marshall |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CREATE A FORMULA FOR HOURS WORKED THAT SUBTRACTS 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) | |||
| 7 day workweek timesheet - excluding lunch | Excel Worksheet Functions | |||
| Time Calculation For A Timesheet To Include Lunch | Excel Worksheet Functions | |||
Threaded Mode
