---
title: "Export Guide: Calculating Talk Time"
slug: "export-guide-calculating-talk-time"
description: "Understand how to measure and analyze talk time, empowering you to optimize resources, enhance customer interactions, and improve overall communication strategies for optimal business performance."
tags: ["analytics", "analytics report", "contact center analytics", "reporting"]
updated: 2025-05-09T01:31:55Z
published: 2025-05-13T04:00:08Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://help.dialpad.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Export Guide: Calculating Talk Time

Knowing your user's talk time helps efficiently allocate resources and aids in effective scheduling. Export your call logs to drill into the details of how much time an individual user spends on the phone.

Let's dive into the details.

**Who can use this**

Dialpad admins and users with Analytics permission can export office-wide call data.

Individual users can export their own call analytics data.

## Export call logs

To export your call logs, head to your Admin Portal from **Dialpad.com**

1. Navigate to **Analytics**
2. Select the desired **User or groups** filter
3. Select a desired date range
4. Select **Export (.csv)**
5. Select **Call Logs**
6. Select **Send Report**

![](https://cdn.us.document360.io/0f28ad44-2863-4372-a27e-c6728808d742/Images/Documentation/export-call-logs(3).png)

That’s it, you'll receive a download link with a CSV file containing the call logs.

## Calculate talk time

Keeping track of talk time (account minutes) helps your business and customer service teams figure out how efficiently they're handling customer interactions.

To see your talk time (calculated in minutes), use the exported call logs file, and apply the following filters:

1. Navigate to the **Direction** column
2. Select the **Inbound** filter

![](https://cdn.us.document360.io/0f28ad44-2863-4372-a27e-c6728808d742/Images/Documentation/image-1705510924532.png)
3. Navigate to the **Category** column
4. Select **Incoming** filter

![](https://cdn.us.document360.io/0f28ad44-2863-4372-a27e-c6728808d742/Images/Documentation/image-1705511085798.png)
5. Navigate to **Target_type** column
6. Select **User** filter

To get the call time value, apply the formula of subtracting the **date_ended**from the **date_connected**column.

![](https://cdn.us.document360.io/0f28ad44-2863-4372-a27e-c6728808d742/Images/Documentation/talk-duration-in-export.png)

To see the total account minutes, calculate the sum of the talk_duration column.

> [!TIP]
> Tip
> 
> Set the format of the **date_connected** and the **date_ended** columns to **Time**, and the talk duration column to **Duration**. This ensures the result is displayed correctly.

## Related

- [Analytics Glossary](/analytics-glossary.md)
- [Analytics: Key Concepts](/analytics-key-concepts.md)
- [Analytics: Charting Data](/analytics-charting-data.md)
- [Analytics FAQs](/analytics-faqs.md)
- [Export Your Analytics Data](/export-your-analytics-data.md)
- [Read Your Exported Analytics](/read-your-exported-analytics.md)