Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I need to be able to get the number of hours between 2 dates but for business
days only. I work for a property managing company and need to know how long it took for our service providers to complete their jobs, but weekends will not be included in the elapsed time. Create date 4/24/2006 1:10:59 PM Complete date 5/9/06 2:42 PM When I used this forula "=SUM(18/24-(E3-INT(E3)),(H3-INT(H3))-8/24)+(NETWORKDAYS(E3,H3)-2)*9/24" it gives me the answer 101.52 hours, which is not correct. Please help!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculating Business Hours Between 2 Dates | Excel Discussion (Misc queries) | |||
adding rows of hours and minutes to get a total | Excel Worksheet Functions | |||
how to calulate time in hours cbetween two different dates? | Excel Worksheet Functions | |||
Subtracting dates to get hours... but I want to skip weekends | Excel Discussion (Misc queries) | |||
Subtracting paid hours from unpaid hours | Excel Worksheet Functions |