On Sun, 17 Jul 2005 19:37:02 -0700, "julieskennels"
wrote:
I want to perform the following calculation.
a & b are dates; c is number of days to be charged for
Check out is 10 am
if a is blank ; cis blank
If current time is after 10am result is b-a+1
if current time is before 10am result is b-a
Having trouble with the time part - sure it is something simple

=IF(ISBLANK(A1),"",IF(HOUR(NOW())9,(B1-A1)+1,B1-A1))

--
"Learning is a behavior that results from consequences."
B.F. Skinner