Real Timestamp and convert to workshift via an IF statement or other

[tonytorero]

Hello all... I have a report where each event entry has a timestamp in the following format: 10/21/2016 13:25

I would like to read this timestamp and display a value in another column displaying the work shift when the action was performed as indicated by the timestamp. We work 24x7 and day shift runs from 7am to 3pm; Evening Shift runs from 3:01pm to 11pm and Night Shift runs from 11:01pm to 6:59am.

I had written the following statement thinking that it would only read the time of day portion of the timestamp standard listed above but my logic was faulty.

=IF(HOUR(E16269)<7,"NIGHT",IF(HOUR(E16269)<15,"DAY",IF(HOUR(E16269)<23,"EVENING")))

I haven't figured out how to accomplish this to date. Any help, synergy you can offer would be greatly appreciated.

Thanks for your consideration.

Tony

[Richard Buttrey]

Hi,

One way with the date & time in A1

Please Login or Register  to view this content.

[tonytorero]

This was absolutely perfect for my need. Thank you for the assistance with this, Richard! I have clicked on the Add Reputation icon for you. Many thanks again...

Best,
Tony

[Richard Buttrey]

This was absolutely perfect for my need. Thank you for the assistance with this, Richard! I have clicked on the Add Reputation icon for you. Many thanks again...

Best,
Tony

That's most kind of you Tony. It was my pleasure.

Now Y'all have a good day - or is it only Texans who say that?

[tonytorero]

Now Y'all have a good day - or is it only Texans who say that?

LOL... While the phrase 'y'all' can be heard up here, north of Texas, it's not too common in the middle of the country. That being said, I can think of a family member or two who may take issue with that statement... Let's put it this way, you won't hear me say it often... if ever!

However, we will say, "Have a good one." in the same manner! So, with no further ado... Have a good one!