Determining a specific time during the day

[Susan Hayes]

Hello

I am trying to write an if statement which can determine a specified time each day.
For example

If it is before 3:00 pm then A2 = before; If it is after 3:00 pm then A2 = after.

Thank you in advance

Susan

 

[Rowan]

You could try:

=IF(HOUR(NOW())<15,"Before","After")

Hope this helps
Rowan

 

[CLR]

Hi Susan..........

Rowan's formula works fine, and does exactly what you asked for, but keep in
mind, it is a volatile thing. If you are working in the file and at 5
minutes till 3 decide to save and quit, A2 will read "before", but if you
open the file again at 5 minutes AFTER 3, A2 will read "after"........NOT
the "before" that it read when you saved...........this is ok, as long as
this is the way you want it to work.....................

Vaya con Dios,
Chuck, CABGx3