get hours between 2 dates subtracting the weekends

[Guest]

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!!

 

[SteveG]

Cynthia,

Try,

=(NETWORKDAYS(E3,H3)-1-MOD(E3,1)+MOD(H3,1))*24


HTH

Stev

 

[SteveG]

Cynthia,

Try,

=(NETWORKDAYS(E3,H3)-1-MOD(E3,1)+MOD(H3,1))*24


HTH

Stev

 

[Guest]

Try this, where A1 is the Start and A2 is the End, the 9 would be how many
hours you want in the day.

+(NETWORKDAYS(A1,A2)+(A2-A1)-YEARFRAC(A1,A2,1)*365)*9

 

[Guest]

That worked, thank you so much!