time calc question

[Sergeant Ron]

Sorry if I posted this in the wrong place.

I have a time field that is formatted to enter time as 12:00 (24 hour format. I need to create a calc that will see the time and determine what particular shift (ie. 7am-3pm, 3pm-11pm, 11pm-7am). I was thinking of using a Case function statement with at getastext function, but it was wasnt working properly. Any suggestions? Thanks Ron

[-Queue-]

Answered here.