LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 24
Default # Events over time?

Looking for an easier way... Would like to plot # events vs time. For this
problem, I have a file that contains a list of patients and arrival times and
want to see where my gaps in coverage exist, so I am looking for a wayt to
generate a plot that says the average wait (I have this time interval for
each patient) from 0100 to 0200 was x minutes, 0200-0300 was y minutes, etc.

I did this once before with 4 hour intervals and it involved defining
variables that identified a particular 4 hour interval, etc., but it was a
bit convoluted and I was hoping for a better way.

Is there anyone who can help me with this?
Thanks in advance!!!!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Graph of events in time jeichner Charts and Charting in Excel 2 February 3rd 09 02:57 PM
Average time spent to # of events Jennifer Excel Worksheet Functions 2 December 11th 08 05:01 PM
Need formula for time between two events k1ngr Excel Worksheet Functions 5 February 27th 08 05:37 AM
Chart for events per unit of time??? Quin Charts and Charting in Excel 2 February 6th 08 04:45 PM
How can I calculate events that happened at the same time? Stuboy28 Excel Discussion (Misc queries) 2 February 28th 07 09:06 PM


All times are GMT +1. The time now is 02:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"