# Request for new output format on time duration field

**URL:** <https://discuss.elastic.co/t/request-for-new-output-format-on-time-duration-field/258870>\
**Category:** Kibana\
**Created:** [December 16, 2020, 2:08pm UTC](https://discuss.elastic.co/t/request-for-new-output-format-on-time-duration-field/258870 "2020-12-16T14:08:19Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![gaz1](https://avatars.discourse-cdn.com/v4/letter/g/e19b73/32.png) [@gaz1](https://discuss.elastic.co/u/gaz1)\
**Post date:** [December 16, 2020, 2:08pm UTC](https://discuss.elastic.co/t/request-for-new-output-format-on-time-duration-field/258870/1 "2020-12-16T14:08:19Z")

</div>

Hi there! I'm not sure where to post this so if someone knows a better place for this topic please let me know.

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/9/b/9ba8f26bb420bdcfd9a3125fcdbb76e985b81699.png)

I need to do some basic calculation and visualization on Kibana with this number format field (e.g. Average time duration).  
The problem is that the default output format in seconds is not very clear just quickly looking at it.  
The "Human Readable" output format doesn't help me either because I need to see the exact time duration average, not just "a few seconds".

I would like an output format like "hh:mm:ss:milisecond", that is far easier to understand.

I appreciate any help I can get on this! Thank you!

---

<div class="post-metadata">

**Author:** ![flash1293](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/flash1293/32/41227_2.png) [@flash1293](https://discuss.elastic.co/u/flash1293)\
**Post date:** [December 16, 2020, 2:30pm UTC](https://discuss.elastic.co/t/request-for-new-output-format-on-time-duration-field/258870/2 "2020-12-16T14:30:29Z")

</div>

If your input is seconds, then you can use the "Number" formatter with the following numeral.js format: `00:00:00` (see [http://numeraljs.com/#format](http://numeraljs.com/#format) under "Time"). It only works for seconds though.

Also feel free to create a feature request here: [https://github.com/elastic/kibana/issues/new?template=Feature\_request.md](https://github.com/elastic/kibana/issues/new?template=Feature_request.md)

---

<div class="post-metadata">

**Author:** ![gaz1](https://avatars.discourse-cdn.com/v4/letter/g/e19b73/32.png) [@gaz1](https://discuss.elastic.co/u/gaz1)\
**Post date:** [December 16, 2020, 2:44pm UTC](https://discuss.elastic.co/t/request-for-new-output-format-on-time-duration-field/258870/3 "2020-12-16T14:44:56Z")

</div>

It worked! Thanks, I really appreciate it!

---

<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:** [January 13, 2021, 2:45pm UTC](https://discuss.elastic.co/t/request-for-new-output-format-on-time-duration-field/258870/4 "2021-01-13T14:45:03Z")

</div>

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