Add a helper columned with

=CHOOSE(INT(K1/TIME(3,0,0))+1,"00:00-03:00","03:01-06:00","06:01-09:00","09:01-12:00")

I will leave you to add the other 4 groups

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Sunnyskies" wrote in message
...
Morning,

I have got records that have been recorded at different times. Now I want
to
group them from 06:00 - 09:00, 09:01 - 12:00, 12:01 - 15:00, 15:01 - 18:00
etc.

So I should have 8 Groups that should make the recordings easier to show
on
a graph.

The times are shown in column D.

Thanks