Cell value determined by the current time and date

  • Thread starter Thread starter jschae
  • Start date Start date
J

jschae

I need a cells value to be displayed depending on the what the current time
of day it is. If the current time is between midnight and noon, then I want
the cell to equal "3rd Shift". If not, then the cell should be "1st Shift".
Any ideas on the best way to accomplish this?
 
Wouldn't that give 3rd shift for times up to 12:59:59.999 ?
You could try
=IF(MOD(NOW(),1)<=0.5,"3rd Shift","1st Shift")
 
Thanks David for pointing that out...

Another way..
=IF(TEXT(NOW(),"AM/PM")="AM","3rd Shift","1st Shift")

If this post helps click Yes
 
Back
Top