topic Re: Breaking down time of day into shifts in Discussions

Breaking down time of day into shifts

lizrdee — Tue, 16 Jul 2019 20:49:05 GMT

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.

Mark_Bailey — Tue, 16 Jul 2019 20:27:34 GMT

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!

Jeff_Perkinson — Tue, 16 Jul 2019 20:50:40 GMT

You might find value in .

lizrdee — Tue, 16 Jul 2019 22:13:19 GMT

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

Mark_Bailey — Wed, 17 Jul 2019 11:09:30 GMT

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.