Too much to do, I am off on a trip Saturday.

--
---
HTH

Bob

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



"Sunnyskies" wrote in message
...
Thank you Bob, solved a massive problem.

Suggest you start your weekend early ..... how about from now.

Cheers

"Bob Phillips" wrote:

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