CODEWITHSUNDEEP
functionexcel-formulacurrent-time
FalcoonnnnPUNCH
FalcoonnnnPUNCH

Reputation: 1

Using the now() function in excel for conditional argument based on current time

I am trying to generate a cell on my shift report for work that automatically differentiates if it is for day-shift or night-shift. Our shifts are 12 hours (7-7), and shift reports are generally sent out within a 60 minute window around the turnover time (6:30-7:30).

My code is currently: IF(NOW()>="8:00 AM","D","N")

I read this code as "if current time is greater than or equal to 8AM, display "D". If the current time is less than 8AM, display "N"." I have set the time as 8:00 AM to ensure that night shift report will stay labeled as "N" up to an hour after the designated shift end. This is to ensure proper labeling even in the case the shift report is delayed (up to one hour).

Currently the code is not behaving as desired but i'm not actually sure what it is doing. Any advice on where i'm going wrong?

Upvotes: 0

Views: 210

Answers (0)

Related Questions