The way I would do this is by creating a function in VB, rather than trying to use nested IFs or something in a formula.

1. Change the format of these cells containing times to 'General' ... you'll see that they change to decimals, this is how excel understands time, as pieces of the day.

2. Press Alt+F11 to open VB. Choose Insert --> Module

3. Paste this into the window that opens up:

Function timegroup(time)

Select Case time

Case time <= 0.375

timegroup = "Before 9am"

Case time <= 0.0395833

timegroup = "9 - 9:30am"

Case time <= 0.416666667

timegroup = "9:30 - 10am"

**' insert additional times here...**

Case Else

timegroup = "unknown time"

End Select

End Function

4. Now, go back to your excel workbook and in column B2 (for example) use the formula you just created by typing... =timegroup(A2)

It will bring back the appropriate timegroup.

5. You will need to continue the code, to include all the time groups you want to have... just copy and paste what is there where it tells you to, changing the <= number and time group.

To find out the number that goes with each time, just run all the times you want in one column of a blank worksheet, copy and paste them into the next column, and change the second column to 'general' format.

Hope that makes some kind of sense!

Cheers