Group Time
 

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

Group Time
 

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

Group Time
 

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

"Sunnyskies" wrote:

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

Group Time
 

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

Group Time
 

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