Time Frame

[SPAPSTER]

I am a complete noob in regards to excel and formulas so any help would be greatly appreciated. I am trying to get a formula to automatically display "Day SHIFT", "SWING SHIFT", or "MID SHIFT depending on the current time. So the time range for "DAY SHIFT" would be 0730 to 1630, "SWING SHIFT" would be 1631 to 2330 and "MID SHIFT" would be 2331 to 0729. Once again any help or info would be greatly appreciated.

 

[Legacy 143009]

Have a nice day

=IF(NOW()-TODAY()>=1411/1440,"MID SHIFT",IF(NOW()-TODAY()>=991/1440,"SWING SHIFT",IF(NOW()-TODAY()>=5/16,"DAY SHIFT","MID SHIFT")))