Posts: n/a

Counting datapoints/records in time interval

Hi group,

I have a lot datapoints (y-axis) over time (x-axis).
What I'd need is now something like an aggregation/counting of the kind:
amount of datapoints in all 1 minute intervals plotted as bars/scatter/...
Is there an easy way in excel to acomplish this?
Is programming needed here? If so, has anyone got a pointer for this IMO
standard problem?

Many thanx in advance
edw.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
time interval calculations in excel	Krishna	Excel Discussion (Misc queries)	6	April 8th 05 02:57 PM
Time Sheets	Lady Layla	Excel Discussion (Misc queries)	1	March 23rd 05 03:22 PM
unmet challenge	boris	Excel Worksheet Functions	2	March 16th 05 02:13 PM
counting time slots	Nick	Excel Worksheet Functions	1	March 11th 05 01:12 PM
Counting Cells with time value	Anthony	Excel Discussion (Misc queries)	2	February 9th 05 08:55 PM

All times are GMT +1. The time now is 05:31 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us