Group Time

[Guest]

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

 

[Bob Phillips]

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)

 

[Guest]

4 groups are ok. time should be continuous. If an event occurs at 15:00:30
it is not in your range of times. Times should be 06:00 - 09:00, 09:00 -
12:00, 12:00 - 15:00, 15:00 - 18:00

 

[Guest]

Thank you Bob, solved a massive problem.

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

Cheers

 

[Bob Phillips]

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)