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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Determine if time is within a windoww 2
want to track time while paste value in multiple column of same roe 1
Adding up total hours worked on employee schedule using various criteria 0
MS Access Date/Time Calculation After Midnight 1
Date/Time Calculations In Query After Midnight 3
Keyboard shortcut for current date and time 1
How to check if time falls between two ranges 0
Yes or blank, depending if value equals or exceeds value found inVLookup table. 4

Back
Top