Hi,

I need a formula that will claculate the following.

I have a list of times in a column displayed as hh:mm. I need to group them into half hour intervals. For example there are 24hrs in a day so 48 half hour groups. I need the relevant time to be grouped. 00:00 to 00:29 would be group1, 00:30 to 00:59 group 2, etc.

Does anyone know a formula that would recognise the time and put it into the relevant group.

What exactly would i need to set up if i currently just have a list of times.

Thank you so much

Greg