get hours between 2 dates subtracting the weekends
 

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

get hours between 2 dates subtracting the weekends
 

Cynthia,

Try,

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


HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=541208

get hours between 2 dates subtracting the weekends
 

Cynthia,

Try,

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


HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=541208

get hours between 2 dates subtracting the weekends
 

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


"Cynthia" wrote:

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

get hours between 2 dates subtracting the weekends
 

That worked, thank you so much!

"SteveG" wrote:


Cynthia,

Try,

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


HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=541208