simple date and time functions

[Guest]

Hello. I am trying to compare the difference between two dates and times
based on a 24 hour structure, including the NETWORKDAYS function. We work on
a 48 hour turn around. Document comes in at 10:00 on 12-06-2005 and out 12:00
12-08-2005 then "no" else "yes". Specific formatting for dates and times seem
to be an issue in NETWORKDAYS where I get the correct date calculation, but
when I enter in the holidays, it returns a VALUE#. I have used mm-dd-yyyy.
Thanks in advance for your help.

 

[Bob Phillips]

How about

=IF(networkdays(A20,A21)-(MOD(A20,1)-MOD(A21,1))>=2,"yes","no")

where A20 is the start date/time, A21 the end.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Bob Phillips]

Forgot the holidays bit, just add that to the NETWORKDAYS

=IF(networkdays(A20,A21,holidays)-(MOD(A20,1)-MOD(A21,1))>=2,"yes","no")

--

HTH

RP
(remove nothere from the email address if mailing direct)