NETWORKDAYS - rounding required.

[Mark]

Hello,

I use Networkdays to calculate the number of working days
between two dates. The product of the calcutaion is only a
whole number, it rounds up effectively.

I have also the times for each of the dates and would like
to use something similar to Networkdays to calculate the
fraction or decimal part of each day.

E.g using networkdays between 5/27/03 14:16 and 6/2/03
12:43 returns a value of 5. What I want to do is return a
value of 4.9354 days.

Any ideas anyone?

Cheers

 

[Mike]

Say: 5/27/03 14:16 in Cell A1 and 6/2/03 12:43 in Cell A2.
Formula: =NETWORKDAYS(A1,A2)+MOD(A2,1)-MOD(A1,1)
Format: General

Ref to "Mark" <[email protected]> wrote in message news:[email protected]...