How to Measure Your Email Response Time in Gmail
"How fast do I reply to email?" is a useful question for anyone managing clients, support, or their own habits — but Gmail does not answer it. There is no built-in stat for response time, and the paid add-ons that calculate it want access to your account. You can work it out yourself with an export and a spreadsheet, and keep all your data on your own machine. Here is how.
What "response time" actually means
Response time is the gap between when a message arrives and when you reply to it within the same conversation. To compute it you need three pieces of data for every message:
- A thread identifier so you can group a conversation together.
- A timestamp precise enough to subtract (date and time, not just date).
- Direction — whether each message was received or sent.
With those, you pair each incoming message with your next outgoing message in the same thread and measure the difference.
Step 1 — Export messages with timestamps and direction
- Install a local exporter. Add Gmail Exporter so the file is built on your device and your data stays private.
- Include both directions. You need received and sent messages together so replies can be matched to the emails they answer. Exporting a conversation or a label that contains both works well.
- Scope to a period if you want a recent picture — use operators from the date-range guide such as
after:2026/01/01. - Export to CSV or Excel and open it. Confirm you have a date/time column and can tell incoming from outgoing. If you need format help, see export Gmail to CSV.
Step 2 — Sort each thread chronologically
Sort the sheet by thread, then by timestamp, so each conversation reads top to bottom in time order. Now within a thread you can see the back-and-forth: an incoming message followed by your reply.
Step 3 — Calculate the gap between message and reply
Add a column that, for each of your sent messages, subtracts the timestamp of the most recent incoming message before it in the same thread. In the simplest case where a reply sits directly below the message it answers:
- Put both timestamps in proper date-time cells.
- Subtract them:
=B3 - B2(sent time minus received time). - The result is in days, so multiply by 24 for hours or 1440 for minutes:
=(B3 - B2)*24. - Format the result cell as a number, not a date, or it will display oddly.
Only keep the gap on rows where an outgoing message follows an incoming one in the same thread; ignore rows where you sent the first message or sent several in a row.
Step 4 — Summarise
With a column of reply gaps, compute the numbers that matter:
- Average:
=AVERAGE(range)— your typical turnaround. - Median:
=MEDIAN(range)— better than average when a few slow replies skew the mean. - Fastest / slowest:
=MIN(range)and=MAX(range).
The median is usually the most honest measure of how you respond day to day.
Get the timestamps Gmail hides
Export your conversations with full dates and direction to a spreadsheet on your device — then calculate response time yourself. Free, private.
Add to Chrome — It's FreeMake it fair: count working hours
A raw gap punishes you for emails that land overnight — a message received at 6pm and answered at 9am looks like a 15-hour response when it was really first thing. Two ways to handle it:
- Filter to business hours. Add an hour column (
=HOUR(timestamp)) and keep only incoming messages received during working hours before averaging. - Use a working-hours calculation. More advanced, but you can subtract non-working time so nights and weekends do not count against you.
Knowing when mail actually arrives helps here — that overlaps with finding your busiest times in how to analyze your Gmail inbox.
Useful cuts of the data
| Question | How to get it |
|---|---|
| My overall reply time | Median of all reply gaps |
| Reply time per contact | Pivot reply gaps by sender |
| Trend over months | Add a YYYY-MM column, pivot average gap by month |
| Who waits longest on me | Sort reply gaps descending, note the senders |
Breaking reply time down by contact is especially useful if you handle clients — pair it with knowing who emails you the most to see whether your slowest replies go to your most frequent correspondents.
If you prefer code
For larger inboxes or repeatable reporting, export to JSON and compute response times in a script. Structured records make thread-pairing and working-hours math much cleaner than spreadsheet formulas. See export Gmail to JSON for developers for the schema.
Keep it private
Reply-time analysis touches the full content of your conversations and exact timestamps. A local export keeps that on your own machine with no upload and no account access required — the reasoning is in is it safe to export your Gmail?
The bottom line
Gmail will not tell you how fast you reply, but the data to work it out is in your threads. Export with timestamps and direction, pair each incoming message with your reply, and summarise the gaps — using the median and, ideally, a business-hours adjustment for a fair picture. Done on a local export, the whole calculation stays private.
Frequently asked questions
How do I measure my email response time in Gmail?
Export messages with timestamps and direction, sort each thread by time, and subtract an incoming message's time from your next reply. Average or take the median of those gaps in a spreadsheet.
Does Gmail show response time statistics?
No. Gmail does not report reply speed. Some paid add-ons do, but you can calculate it yourself from an export with timestamps.
What data do I need to calculate reply time?
A thread or conversation identifier, a precise timestamp per message, and the direction (received or sent). Those three let you pair messages with replies.
How do I calculate the time between two emails in a spreadsheet?
Subtract the two date-time cells. The result is in days, so multiply by 24 for hours or 1440 for minutes, and format the cell as a number.
Should I measure during business hours only?
For fairness, yes — a raw gap counts nights and weekends. Filter to business hours or use a working-hours calculation.
Can I measure response time without sending my data to a server?
Yes. A local extension builds the export on your device and you calculate in your own spreadsheet, so nothing reaches a third-party server.