group by time of day

[jtlrlfrc]

Hi everyone, I'm trying to simply group values by time of day to assign a 'group name'

For example

If Time is between 9.30am and 12:30pm then "Morning"

If Time is between 12:30pm and 3:30pm then "Afternoon"

If Time is between 3:30pm and 6:30pm "Late Afternoon"

If Time is between 6:30pm and 9:30pm then "Evening"

I'm trying this in custom column, but keep getting errors so I'm unsure of the simplest way to approach this.

Thanks in advance if you can lend some advice!

[Greg_Deckler · Accepted solution]

Here is a sample:

Column = IF([Time]>TIMEVALUE("9:30 AM") && [Time]<TIMEVALUE("12:30 PM"),"Morning","Not Morning")

Basically big nested IF statement.

[jtlrlfrc]

Thanks smoupre! I see exactly where I went wrong