Hi Spencer,

Am Thu, 21 Feb 2013 10:10:12 +0000 schrieb Spencer101:

But you don't really need the value in C1. You cold just have

=IF(NOW()B1,"Available","Unavailable")

NOW() is date + time and it is always greater than a time.
Just in this moment NOW is 41326,6111829861
and CTRL+SHIFT+Point = 0,6111829861


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2