Metropolitan Hospital, a very large urban hospital, promises patients that there will be no more than a 60-minute wait between the time they arrive (sign in) at the emergency services department until they are triaged. The hospital selected 10 patients at random to check the times. Use Excel to calculate the wait time between arrival and triage.

Calculate the wait time for each patient (format as time with no AM/PM designation).

Patient	Time of Arrival	Time Patient was Triaged	Wait Time
Patient A	8:00 a.m.	8:23a.m.	Answer
Patient B	8:23 a.m.	8:56a.m.	Answer
Patient C	8:56 a.m.	9:20a.m.	Answer
Patient D	9:45 a.m.	10:46a.m.	Answer
Patient E	10:20a.m.	1:45 p.m.	Answer
Patient F	11:20a.m.	1:50 p.m.	Answer
Patient G	12:15 p.m.	2:40 p.m.	Answer
Patient H	1:05p.m.	2:56p.m.	Answer
Patient I	3:27p.m.	5:05p.m.	Answer
Patient J	4:05p.m.	4:56p.m.	Answer

What is the average wait time?

Answer

Is the hospital in compliance with its own guidelines?

Answer