Hi Everyone,

I am using Excel 2000 and am a beginner.  We are going to be doing some QI testing for our department in our hospital.  We will be looking at tracking a few things.  The most important is to track which therapists take the most time to start treatments and also get a general idea of how long it takes to start treatments once they are ordered in general.  Another thing I can see from this is we could also track which floors are taking too much time from the time the order was written to the time it was received on our fax machine.  Additional questions are in parentheses.

Here are the column headers except for the items in quotes.

"Type of Therapy"

Time Order Written
Time Fax Received
Time therapy Instructed/Started
Therapist Name

(What is the best way to format the time cells so we can calculate in minutes and/or hours the difference?)

"Order Types"

Aerosol Treatment
Order Set
MDI Instruction

(I think I need to make a yes no field for these items and a patient can be on more than one but I'm not quite sure how this works or how to set it up)

Thanks,
Linda