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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating a formula to display # of work hours spent on a project
If you have Excel 2003, you can download
Wekly Timesheet (8/12x11, landscape) Allows you to plug in the information and calculates the info for you... Another thing is to do this.. A B C D E In Out Lunch In Lunch Out Hours Worked 9:00 am 12:00 pm 1:00 pm 5:00 pm =(b-a)+(d-c) And make sure all fielsds re formatted as Time. "KerryM1212" wrote: 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! |
Reply |
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 |