If-Then-Else for TIME range

Ask for Help
2

You can go with this.

Create a math column to derive the hour from your time. HOUR(T) with T pointing to the full timestamp.

Then from that hour number, create an If Then Else column.

If Hour is greater than 18 then Evening.
If Hour is greater than 11 then Afternoon.
If Hour is greater than 6 then Morning.
Else Evening.

Something like that.

1 Like