Drop your CSV export here
or paste it below. Nothing leaves your browser.
How long customers waited
Columns and date format
What the numbers mean
Median first response is what a typical customer waited for your first reply, in calendar time, nights and weekends included. It is the number your customers feel. Median in working hours counts only the minutes inside the hours you set, which is the fairer number for judging how quickly your team picks things up. A big gap between the two means most of the waiting happens while nobody is working.
Replied within an hour is the share of all conversations, including the ones that never got a reply, that heard back within 60 minutes. Never got a reply counts rows with a start time and no reply. Leaving those out makes any average look better than it was.
Under the tiles, the calculator says how many conversations came in outside your working hours and how long those customers waited compared with everyone else. For most small teams that is where the slow replies are.
How to get your export
Most help desks and chat tools have a CSV export of conversations or tickets in their reports or settings. Look for a created or started time and a first reply or first response time. If your export already has a first response time column, choose "One column with the wait" under Columns and date format. If both times are in UTC, the calculator asks for your time zone so working hours line up with your day.
Two things to check before you trust the result. Some tools count an automatic "we got your message" as the first reply, which makes the number look far better than what customers felt. And if your export mixes channels, email will pull the median up compared with live chat, so compare like with like.
Bringing it down
If most of the waiting happens outside your hours, staffing more hours is the expensive fix. The cheaper one is an assistant that answers what your docs already cover at any hour, hands everything else to you with a note saying why, and tells the customer a person will reply where they are. We measured what that did to our own first response time, and where it still fell short, in first response time, with real numbers.