Breaking down time of day into shifts

[#1]

Hello, 

I have time data that I would like to breakdown into shifts to analyze shift patterns 
9:00PM-5:59AM = night shift

6:00AM-11:59AM = morning shift

12:00PM-8:59PM = afternoon shift

Can anyone provide any guidance on how to do this with a formula or script? I'm a beginner and am just using recode which is very slow. 

[#2 · Accepted solution]

You can copy this script and then paste it as the formula for the second column:

If(
	In Hours( 6 ) <= :CST < In Hours( 12 ), "Morning Shift",
	In Hours( 12 ) <= :CST < In Hours( 21 ), "Afternoon Shift",
	"Night Shift",
);

I can't test it but you can! 

[#3]

Thank you so much it worked! I was wondering how to format the formula so this was really helpful.

[#4]

You might find value in Using dates, times, datetimes and durations in JMP. 

[#5]

I amended my solution to use literal times instead of computing them.

If(
	06:00:00 <= :CST < 12:00:00, "Morning Shift",
	12:00:00 <= :CST < 21:00:00, "Afternoon Shift",
	"Night Shift",
);

I think that it improves the legibility and efficiency of this formula.