# Calculate Duration from Specific Fields Using DQL

**URL:** <https://community.dynatrace.com/t/calculate-duration-from-specific-fields-using-dql/52602>\
**Category:** DQL\
**Tags:** dql\
**Created:** [July 22, 2025, 9:53pm UTC](https://community.dynatrace.com/t/calculate-duration-from-specific-fields-using-dql/52602 "2025-07-22T21:53:55Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![goutham\_a](https://avatars.discourse-cdn.com/v4/letter/g/ecd19e/32.png) [@goutham\_a](https://community.dynatrace.com/u/goutham_a)\
**Post date:** [July 22, 2025, 9:53pm UTC](https://community.dynatrace.com/t/calculate-duration-from-specific-fields-using-dql/52602/1 "2025-07-22T21:53:55Z")

</div>

Calculate Duration from fields (StartTime and EndTime) and display the start date

| Task | StartDate | EndDate | StartTime | EndTime |
| --- | --- | --- | --- | --- |
| A | 7/21/2025 | 7/21/2025 | 23:00:01 | 23:09:24 |
| B | 7/22/2025 | 7/22/2025 | 00:59:53 | 01:24:01 |

Need to calculate duration from&nbsp;23:00:01 to&nbsp;01:24:01 and display date as&nbsp;7/21/2025 and duration.

---

<div class="post-metadata">

**Author:** ![p\_devulapalli](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/p_devulapalli/32/41590_2.png) [@p\_devulapalli](https://community.dynatrace.com/u/p_devulapalli)\
**Post date:** [July 23, 2025, 2:04am UTC](https://community.dynatrace.com/t/calculate-duration-from-specific-fields-using-dql/52602/2 "2025-07-23T02:04:09Z")

</div>

[@goutham\_a](https://community.dynatrace.com/user/86038)&nbsp;You can try similar to below as an example

> **[DQL data types](https://docs.dynatrace.com/docs/platform/grail/dynatrace-query-language/data-types)**
>
> A list of DQL data types.

```markup
| fieldsAdd duration = (timeframe[end]) - (timeframe[start])
    | fields duration, timeframe[start]

```

 ![p_devulapalli_0-1753236133235.png](https://global.discourse-cdn.com/dynatrace/original/2X/a/aa28eb9db0b6787abff2ee5f0cf02357375a9380.png)