NETWORKDAYS Function

[BCS2]

I am trying to determine the elapsed time between a start and dtop time. I am doing so now by subtracting one from the other. Which works fine until I get to a weekend.

I am assuming this function counts up until Friday night @ midnight and roll into Monday. The problem I have run into is that the results are displayed as whole days. I would like to display as [H]:mm.

An example of a test I am using is below.

Thanks All.

Estimate Tracking Example.xls
	A	B	C	D
1	1/9/0411:00AM	1/12/0410:49AM	2.00
2
3	1/6/049:00	1/6/0411:00	1.00
Sheet1

 

[barry houdini]

Are you looking to get the number of days or hours?

If you want total weekday hours then format as [h]:mm

BTW you can simplify formula to:

=NETWORKDAYS(A1,B1)+MOD(B1,1)-MOD(A1,1)-1

 

[megnin]

I'd like to get days, hours and minutes, but days and hours, at least.

 

[barry houdini]

Then use the formula I gave....

=NETWORKDAYS(A1,B1)+MOD(B1,1)-MOD(A1,1)-1

and format as dd:hh:mm

although this doesn't work for results over 31 days, in which case you could try

=NETWORKDAYS(A1,B1)-1-(MOD(A1,1)>MOD(B1,1))&" hours"&TEXT(MOD(B1,1)-MOD(A1,1)+(MOD(A1,1)>MOD(B1,1))," hh:mm")