How to check Time if it Falls in certain Condition

[sgaryali]

Hi

I want to create flag 0 and 1 for the shifts which moves to next day.

For ex -

ID 101 shift is in same day 07:00 - 17:30

ID 105 shift falls in next day 21:00- 07:30

How can we achieve this?

Thank you in advance.

[binuacs]

@sgaryali One way of doing this 

[chuckleswk · Accepted solution]

You can use something like the following flow to split out the Schedule column, convert the split columns to a time and then use a formula to check if the end time is less than the start time.