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
|