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
Hi
Please can you support me from scratch with a similar query below.
1. How do i separate date and time and then
2. How do i create Shifts. Shift 1 06:00 - 14:00, Shift 2 14:00 - 22:00 and Shift 3 22:00 - 06:00
Would really apprecite your support
Thanks
Jerry
Hello @jhaldane,
Seperate date and time Using split option is available.
and then no need of date on only using time you can write conditions like
Category =
VAR hour =
HOUR ( [Time] )
RETURN
"Shift "& IF ( hour >= 6 && hour < 14, "A", IF ( hour >= 14 && hour < 22, "B", "C" ) )its may help
Regard ,
pooja