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)


"Lee" wrote in message
...
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.