Help with IF Function for times.
Hi,
Am Thu, 21 Feb 2013 05:02:12 +0000 schrieb Ryanoo:
Basically I would like A1 to check if the current time (c1) is later
than B1.
If the argument is true (if C1 is later than B1) it should return
Available?
If it is false (not later) then it should return un-available.
try:
=IF(MOD(C1,1)B1,"Available?","Unavailable")
Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
|