| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Schedule hours calculation
I am putting together a simple excel spreadsheet to calculate hourly
schedules for my employees. What I would like it to do is calculate the hours of the week and subtract 1 hour per day for lunch hours. So it is setup as follows A1 - Name B1 - Start C1 - Finish (Monday) (-1 hour lunch) D1 - Start E1 - Finish (Tuesday) (-1 hour lunch) etc.. N1 - Total hours for the week |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Working days and hours calculation - request assistance please! | Excel Worksheet Functions | |||
| Calculation of hourly rate times hours times 1.5 | Excel Worksheet Functions | |||
| adding rows of hours and minutes to get a total | Excel Worksheet Functions | |||
| Calculation of full hours | Excel Worksheet Functions | |||
| How can I make an Employment Schedule that Tabulates hours worked. | Excel Worksheet Functions | |||
Threaded Mode
