Results 1 to 15 of 15

Calculating numberr of patients seen every two hours in ED

Threaded View

  1. #1
    Registered User
    Join Date
    10-26-2014
    Location
    Leavenworth, WA
    MS-Off Ver
    2010
    Posts
    82

    Calculating numberr of patients seen every two hours in ED

    Hi;
    I need to find out how many patients are seen every two hours per day of week for an entire year in the emergency department.
    I've included a small data set that I have cleaned up from the electronic medical records.
    What I am trying to discover:
    The busiest times in the emergency department so that I can staff accordingly.

    The actual data set is HUGE. It is for an entire year. But once I have a formula, I can calculate for the entire year.

    And as an FYI: I have learned formulas on this forum that I have used so much in my work...so THANK YOU FOR YOUR HELP!!!!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 5
    Last Post: 04-13-2017, 11:05 AM
  2. Formula to count number of patients per time interval over 24 hours+
    By RM1984 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-27-2014, 11:30 AM
  3. Calculating number of patients by arrival time (hr)
    By alowry in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 05-30-2013, 02:33 PM
  4. Replies: 7
    Last Post: 07-25-2012, 09:14 AM
  5. Calculating # of Patients in process by Hour of Day
    By jsolofly in forum Excel General
    Replies: 8
    Last Post: 04-27-2012, 03:36 PM
  6. Replies: 1
    Last Post: 11-29-2011, 12:19 AM
  7. Calculating Patients Per Hour of Day
    By Skoal in forum Excel General
    Replies: 0
    Last Post: 05-10-2005, 03:37 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1