| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I calculate the week day hours between 2 days
I need to calculate the difference in hours between when I received a project
and when when I completed the project. Within this time frame I do not want to count weekends and I want the workday to be 8:00 am to 8:00 pm. Example (9/11/5 8:00 am started and 9/12/5 8:00 am finished)= 12 hours not 24 hours Is there an easy way to do this? -- Mickey |
|
#2
|
|||
|
|||
|
Take a look at Chip Pearson's solution at
http://www.cpearson.com/excel/DateTimeWS.htm Steve "Mickey" wrote in message ... I need to calculate the difference in hours between when I received a project and when when I completed the project. Within this time frame I do not want to count weekends and I want the workday to be 8:00 am to 8:00 pm. Example (9/11/5 8:00 am started and 9/12/5 8:00 am finished)= 12 hours not 24 hours Is there an easy way to do this? -- Mickey |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel needs hh:mm where hh>24 for hours worked per week | Excel Worksheet Functions | |||
| calculate hours just can't figure it out | Excel Worksheet Functions | |||
| calculate difference in time to hours | Excel Worksheet Functions | |||
| calculate average hours and minutes | Excel Worksheet Functions | |||
| calculate average hours worked | Excel Worksheet Functions | |||
Linear Mode
