Thread: Group Time
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
joel joel is offline
external usenet poster
 
Posts: 9,101
Default 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