# Any possibility calculate Average Duration in HH:mm:ss format **URL:** \ **Category:** Kibana\ **Created:** [April 11, 2019, 9:27am UTC](https://discuss.elastic.co/t/any-possibility-calculate-average-duration-in-hhss-format/176365 "2019-04-11T09:27:21Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![kovas6](https://avatars.discourse-cdn.com/v4/letter/k/f9ae1b/32.png) [@kovas6](https://discuss.elastic.co/u/kovas6)\ **Post date:** [April 11, 2019, 9:27am UTC](https://discuss.elastic.co/t/any-possibility-calculate-average-duration-in-hhss-format/176365/1 "2019-04-11T09:27:21Z")
Hi, I have Average calculation for job execution Duration in Kibana on one number field. The problem is that number field provides view in number format like 3,43 min or in Human Readable format which is not accurate in both cases. Is any way we could get number format changed to time HH:mm:ss format during Average Duration calculation? I have tried Date type but it does not calculates Averages on Date type. I tried adding Scripted Field, but also with no luck. Any advise? Thanks ---
**Author:** ![kovas6](https://avatars.discourse-cdn.com/v4/letter/k/f9ae1b/32.png) [@kovas6](https://discuss.elastic.co/u/kovas6)\ **Post date:** [April 12, 2019, 10:34am UTC](https://discuss.elastic.co/t/any-possibility-calculate-average-duration-in-hhss-format/176365/2 "2019-04-12T10:34:08Z")
any thoughts? ---
**Author:** ![Marius\_Dragomir](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marius_dragomir/32/42087_2.png) [@Marius\_Dragomir](https://discuss.elastic.co/u/Marius_Dragomir)\ **Post date:** [April 12, 2019, 12:51pm UTC](https://discuss.elastic.co/t/any-possibility-calculate-average-duration-in-hhss-format/176365/3 "2019-04-12T12:51:57Z")
Hello, Right now there isn't a way to do this exactly. Best option would be to have a scripted field, that gets the value of that duration field and then converts it from seconds to a HH:mm:ss format. You can use typical Java date libraries in a Kibana scripted field so documentation is widely available for that. ---
**Author:** ![kovas6](https://avatars.discourse-cdn.com/v4/letter/k/f9ae1b/32.png) [@kovas6](https://discuss.elastic.co/u/kovas6)\ **Post date:** [April 12, 2019, 5:26pm UTC](https://discuss.elastic.co/t/any-possibility-calculate-average-duration-in-hhss-format/176365/4 "2019-04-12T17:26:30Z")
Hi, If I use Java date libraries what type I would get in output? I tried converting number to date in scripted field ![image](https://us1.discourse-cdn.com/elastic/original/3X/a/3/a3808d7364d621ad853c6f6ebe81584c3e89a3df.png) But can not calculate Average in Kibana's visualization ---
**Author:** ![kovas6](https://avatars.discourse-cdn.com/v4/letter/k/f9ae1b/32.png) [@kovas6](https://discuss.elastic.co/u/kovas6)\ **Post date:** [April 15, 2019, 11:17am UTC](https://discuss.elastic.co/t/any-possibility-calculate-average-duration-in-hhss-format/176365/5 "2019-04-15T11:17:43Z")
Also tried some calculation script in Scripted Field doc['duration'].value + ":" + doc['duration'].value / 60 ![image](https://us1.discourse-cdn.com/elastic/original/3X/0/f/0f1a2488983eb5fdbc5739ee68d0f0aa8f1fc551.png) But got NA for that field in Kibana's Discovery Does anyone had this issue? Many thanks ---
**Author:** ![kovas6](https://avatars.discourse-cdn.com/v4/letter/k/f9ae1b/32.png) [@kovas6](https://discuss.elastic.co/u/kovas6)\ **Post date:** [April 18, 2019, 6:15am UTC](https://discuss.elastic.co/t/any-possibility-calculate-average-duration-in-hhss-format/176365/7 "2019-04-18T06:15:55Z")
any idea? ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [May 16, 2019, 6:15am UTC](https://discuss.elastic.co/t/any-possibility-calculate-average-duration-in-hhss-format/176365/8 "2019-05-16T06:15:59Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.