Time Reference

[Guest]

Can anyone help!

I'm trying to enter a formula within a worksheet which references time. It
should be quite simple but it doesn't work. eg
=if(now()>q13,"do this",if(now()>q14,"do that",""))

Both q13 and q14 are formated to the time format and contain the times 08:30
and 09:30 respectivly.

I've been advised to use the MOD function, but this only provides the
remainder, and produces an error within the formula.

 

[Bob Phillips]

Lee,

NOW() is date and time, so you need to strip the date

=IF(MOD(NOW(),1)>Q13,"do this",IF(MOD(NOW(),1)>Q14,"do that",""))

--

HTH

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