Shift wise Date time and grouping

[Anonymous]

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

Regards ,
pooja

[javieezy]

Hi, what if my shift ends at 10:30? 

[jhaldane]

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

[Anonymous]

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

[v-shex-msft · Accepted solution]

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

[Karol_Janas]

Hi Xiaoxin Sheng and comunity, I have tried this:

Category = 
VAR hour =
    HOUR ( [Time] )
RETURN
  "Shift "&  IF ( hour >= 6 && hour < 14, "A", IF ( hour >= 14 && hour < 22, "B", "C" ) )

but it did not work. Any advice?

Thx a lot.

Karol

[javieezy]

Hi, what if my shift ends at 10:30? 

[koray]

Did you solved this? I have smilar problem.