Help on Networkdays

I'm trying to find the number of business (working) days between two dates.
I am using the Networkdays function however it returns the number of whole workdays between two dates. Eg. 1.00 or 2.00
or 3.00
I need fractional days in order to denote a certain time of day.

Eg.

Start date: Friday, September 2, 2005
End date: Wednesday, September 7, 2005

Holidays: Labour Day: September 5, 2005

The answer received is 3.00

However I need to set a time as of 3:00 pm on September 7 for example.

Start date: Friday, September 2 1
Tuesday, September 6 1
Current date Wednesday, Septmeber 7 15/24

Total 2..625


Thank you

Susan

Hi Susan,

Assuming
your start date in A1
your End Date in B1
Holidays is your range of holidays! :

=IF(A1>B1,0,NETWORKDAYS(A1,B1,Holidays)
-IF(NETWORKDAYS(A1,A1,Holidays),MOD(A1,1))
-IF(NETWORKDAYS(B1,B1,Holidays),1-MOD(B1,1)))

Format as Number with decimals :

Regards,

Daniel M.

"Susan Hayes" <asdf@hotmail.com> wrote in message
news:hipuh1lbgha9i0qjmhnoj401bv51u7t791@4ax.com...
> I'm trying to find the number of business (working) days between two dates.
> I am using the Networkdays function however it returns the number of whole
workdays between two dates. Eg. 1.00 or 2.00
> or 3.00
> I need fractional days in order to denote a certain time of day.
>
> Eg.
>
> Start date: Friday, September 2, 2005
> End date: Wednesday, September 7, 2005
>
> Holidays: Labour Day: September 5, 2005
>
> The answer received is 3.00
>
> However I need to set a time as of 3:00 pm on September 7 for example.
>
> Start date: Friday, September 2 1
> Tuesday, September 6 1
> Current date Wednesday, Septmeber 7 15/24
>
> Total 2..625
>
>
> Thank you
>
> Susan