Field note · 11 March 2026
How to read ED wait bands without drowning in spreadsheets
A practical guide for operations leads who need to brief leadership on emergency department waits using three simple bands.
Emergency department waits are often reported as a single average. That number hides the patients who waited far longer than the mean and the quiet hours that pull the average down.
We recommend three wait bands tied to your local triage categories: under target, approaching target, and beyond target. Report counts in each band for the last seven days, not only the average minutes.
When briefing a board, show the beyond-target count first, then the day of week pattern. Occupancy on medical wards often explains Monday and Tuesday spikes more clearly than staffing alone.
Ask your records team for arrival time, first clinician contact, and disposition. If disposition is missing, you can still use time-to-decision as a temporary proxy while you tighten documentation.
Keep the visual simple: a stacked bar by day is usually enough. Resist adding every available column from the source extract; the goal is a conversation about capacity, not a tour of the spreadsheet.