Conditional IF formula with time variable

[krishnagandhi]

Hi,

I have been trying to figure this out but no luck. I have date in the date timer format. I parse the time out to a separate column and i am trying to write a formula that says if the time is after 17:30  and terminal type is onsite then classify as night shift, else if time is before 17:30 and terminal type is onsite then day shift else 0. But i am getting an error. Is this possible?

[AbhilashR · Accepted solution]

Hi @krishnagandhi, I put together a simple solution to help demonstrate your solution.

I convert the DateTime field to just Time and then write a formula to identify Shifts

Let us know if this works on your larger dataset.

[cplewis90]

Hello @krishnagandhi,

Similar to @AbhilashR, but a slight adjustment to the shift formula: