September 16, 200520 yr 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
Create an account or sign in to comment