# Difference duration calculation between start and end time to show in table

**URL:** https://discuss.elastic.co/t/difference-duration-calculation-between-start-and-end-time-to-show-in-table/330137
**Category:** Kibana
**Created:** [April 17, 2023, 1:22pm UTC](https://discuss.elastic.co/t/difference-duration-calculation-between-start-and-end-time-to-show-in-table/330137 "2023-04-17T13:22:52Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![PRASHANT\_MEHTA](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/prashant_mehta/32/101764_2.png) [@PRASHANT\_MEHTA](https://discuss.elastic.co/u/PRASHANT_MEHTA)
#### Post date: [April 17, 2023, 1:22pm UTC](https://discuss.elastic.co/t/difference-duration-calculation-between-start-and-end-time-to-show-in-table/330137/1 "2023-04-17T13:22:52Z")

</div>

Hello All,

I'd like to know how can I calculate the duration difference between start execution-end execution(Date format) and only get the duration to show in third column.  
How can this be done?,backend only provides the start and end date.Third column in image is requirement.

In below image I've start and end date in YYYY-MM-DD hh:mm:ss and in third column I need only diffrence between end(hh:mm:ss)-start(hh:mm:ss)  
 ![image](https://us1.discourse-cdn.com/elastic/original/3X/4/8/48da3578c9036a9548e3d033302ec61a1be039ed.png)

kibana and enhanced table plugin 7.9.1  
Thanx

---

<div class="post-metadata">

### Author: ![patterno](https://avatars.discourse-cdn.com/v4/letter/p/5e9695/32.png) [@patterno](https://discuss.elastic.co/u/patterno)
#### Post date: [May 14, 2023, 4:34am UTC](https://discuss.elastic.co/t/difference-duration-calculation-between-start-and-end-time-to-show-in-table/330137/2 "2023-05-14T04:34:03Z")

</div>

> [@PRASHANT\_MEHTA](#):
>
> ion(Date format) and only get the duration to show in third column.

What function did you use in the start time and end time?

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)
#### Post date: [June 11, 2023, 4:34am UTC](https://discuss.elastic.co/t/difference-duration-calculation-between-start-and-end-time-to-show-in-table/330137/3 "2023-06-11T04:34:58Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.