Group based on time slots

[Ms996]

How can I group my time's for a event in Column A displayed as HH:mm (ex 09:27 AM) in certain categories in Column B

I have 3 categories :

06:59 AM to 09:59 AM - Timeslot A
10:00 AM to 03:59 PM - Timeslot B
Everything Else - Timeslot C

Please let me know how can I achieve this for my dataset

P.s : posted on other forums as well for help

 

[etaf]

i would create a helper column in the data set and the group using that
=IF( AND ( A2 >= timevalue("06:59") , A2 < = timevalue("09:59")), "Timeslot A", IF ( AND ( A2 >= timevalue("10:00") , A2 < = timevalue("15:59")), "Timeslot B","Timeslot C"))

 

[Ms996]

What do you mean helper column ?

 

[etaf]

An Additional column in the data set