| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating a formula to display # of work hours spent on a project
I wasn't quite sure where to put this question.
Is there anyway to calculate the # of work hours spent on a project given 2 seperate dates and times, taking into account a work day of 8-5 with an hour lunch? For example, if I work 8-5, start a project on 8/3 at 9 and finished it on 8/7 at 4, the answer would be 22 work hours. Any ideas would be greatly greatly greatly appreciated. Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Running Total for Time Spent for a project in 1 month | Excel Worksheet Functions | |||
| Formula to work out hours worked | Excel Discussion (Misc queries) | |||
| summing up hours spent on jobs | Excel Discussion (Misc queries) | |||
| how do I calculate hours spent x an hourly rate? | Excel Worksheet Functions | |||
| How do I calculate the hours spent on a project by entering a sta. | Excel Worksheet Functions | |||
Threaded Mode
