Time Q

  • Thread starter Thread starter Seanie
  • Start date Start date
S

Seanie

How could I construct a formula that says:- IF the Time NOW is > 18:00
but < 24:00, carry out formula A, if Not then carry out Formula B?

What I can't get my head around is extracting the time element from
the NOW() function (and not the date.
 
Either of these will give you the current "Now" time...

=NOW()-TODAY()

=MOD(NOW(),1)
 
Back
Top