View Single Post
  #1   Report Post  
Cowtoon
 
Posts: n/a
Default Too many data points

I have data that's collected every two minutes, 24 hours a day and only want
to chart the data for every hour (on the hour). How do I extract that
information, so that my generated chart doesn't look a huge blob of ink.
There must be a formula that can extra the info (say ... if the minutes =
00), that places it in another worksheet where I can generate a
less-cluttered chart from those data.

Thanks for any assistance.
Diana