AnsweredAssumed Answered

calculate shift name from timestamp

Question asked by rubinjm on Apr 7, 2016
Latest reply on Apr 18, 2016 by Extensitech

I have a timestamp field named ROOMED TIMESTAMP and would like to calculate a shift name based on the time. I was going to use the CASE function but can't figure out the right way to enter the time ranges.

 

The timestamp field looks like 1/24/2016 1:29 PM

 

The shift names are

DAY = 0630...1500

PM = 1501...2300

NIGHT = 2301...0629

Outcomes