Function needed to calculate arrival patterns
Currently, I only have about 2 months of data (I believe about ~1200 cells),
but I'd like to keep a running count for a 12 month period. The date and
time stamps are separate, so I currently put all timestamps on one worksheet
in one column sorted by time.
I was originally thinking of having another column with 1/2 hour increments
and then a formula next to that 30 minute block that went through the entire
column of timestamps, counted how many occurred within those 30 minutes and
then give me a number. Those numbers could then be used in a chart.
I might be totally off or complicating things too much. Please let me know
if you have any suggestions. End result=chart showing number of calls per
given 30 minute block of time.
Thanks!
"Pete" wrote:
How many days of information do you have? If it is for 1 month, then
you will have 30 (or 31) times 48 cells of derived data. Do you want
this organised as a table of 48 cells across by 30 down, or as a list
of nearly 1500 cells in one column, or are you only interested in the
arrivals by half hour blocks for the consolidated month?
I assume you have date and time data for each call - are these in
separate columns or combined into one column?
You should be able to use the COUNTIF( ) function, but details of how
to use it will vary depending on the exact nature of your data and how
you want the output to appear.
Hope this helps - post back with further details if you require further
help.
Pete
|