Forum Discussion
Shift wise Date time and grouping
Hello , I have date and time data using i want to calcualate Shift Shift A: 6AM to 2PM Shift B: 2PM to 10PM Shift C: 10PM to 6AM how i calculate last shipt becouse that is in next 4 hr ...
HI Anonymous,
I'd like to suggest you add calculated column to marking tag. Then you only need to calculate out nearest time to find out the correspond ship.
Category = VAR hour = HOUR ( [Time] ) RETURN "Shift "& IF ( hour >= 6 && hour < 14, "A", IF ( hour >= 14 && hour < 22, "B", "C" ) )Regards,
Xiaoxin Sheng
javieezy
Helper I
Helper IHi, what if my shift ends at 10:30?
Did you solved this? I have smilar problem.