Time Reference
 

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.

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.