# How to convert miliseconds into hh:mm:ss using plainless

**URL:** <https://discuss.elastic.co/t/how-to-convert-miliseconds-into-hhss-using-plainless/263006>\
**Category:** Elasticsearch\
**Tags:** painless\
**Created:** [February 2, 2021, 3:33pm UTC](https://discuss.elastic.co/t/how-to-convert-miliseconds-into-hhss-using-plainless/263006 "2021-02-02T15:33:40Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![mohanss08](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mohanss08/32/82297_2.png) [@mohanss08](https://discuss.elastic.co/u/mohanss08)\
**Post date:** [February 2, 2021, 3:33pm UTC](https://discuss.elastic.co/t/how-to-convert-miliseconds-into-hhss-using-plainless/263006/1 "2021-02-02T15:33:41Z")

</div>

With ELK - 7.10.1 i am trying to visualize kibana using painless script, Currently i have logstash output data in the below format.

```
"build_end_time" => "2021-01-13 01:29:49",
"build_duration" => "6409651",
"build_start_time" => "2021-01-12 23:43:00",
"build_date" => "2021-01-12",
"@timestamp" => 2021-02-02T11:40:50.747Z,

```

Here `build_duration` i have in milliseconds. how do i covert into `hh:mm:ss`? Below is my painless script settings.

 ![1](https://us1.discourse-cdn.com/elastic/original/3X/3/6/36227b67702dc071b05584e45b265dd7aa19d3f6.png)

```
   String milliSinceEpochString = doc['build_duration'].value;
long milliSinceEpoch = Long.parseLong(milliSinceEpochString);
Instant instant = Instant.ofEpochMilli(milliSinceEpoch);
ZonedDateTime zdt = ZonedDateTime.ofInstant(instant, ZoneId.of('Z'));
return zdt

```

The above code is not working, basically i need to create daily average build duration visualization with the script field. Can someone help me to achieve the same?

---

<div class="post-metadata">

**Author:** ![Badger](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/badger/32/25190_2.png) [@Badger](https://discuss.elastic.co/u/Badger)\
**Post date:** [February 3, 2021, 3:28am UTC](https://discuss.elastic.co/t/how-to-convert-miliseconds-into-hhss-using-plainless/263006/2 "2021-02-03T03:28:40Z")

</div>

This does not feel like a logstash question. Either you are asking about a presentation issue in kibana, or you are asking about a scripting issue when indexing (which would make it an elasticsearch question).

---

<div class="post-metadata">

**Author:** ![mohanss08](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mohanss08/32/82297_2.png) [@mohanss08](https://discuss.elastic.co/u/mohanss08)\
**Post date:** [February 3, 2021, 3:31am UTC](https://discuss.elastic.co/t/how-to-convert-miliseconds-into-hhss-using-plainless/263006/3 "2021-02-03T03:31:54Z")

</div>

Ok i will move to elasticsearch category.

---

<div class="post-metadata">

**Author:** ![mohanss08](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mohanss08/32/82297_2.png) [@mohanss08](https://discuss.elastic.co/u/mohanss08)\
**Post date:** [February 4, 2021, 7:50am UTC](https://discuss.elastic.co/t/how-to-convert-miliseconds-into-hhss-using-plainless/263006/4 "2021-02-04T07:50:44Z")

</div>

In my index already i have field called `build duration` but it is in `string` type, Since i want to visualize the average of `build_duration` In Line chart Y-axis i want to select `Average` but if i select it shows `The index pattern build-info does not contain any of the following compatible field types: number or histogram` So for this reason i am looking to create scripted field to calculate the build duration average. currently it is in milliseconds need help to convert into `HH:mm:ss` format, Any help would be highly appreciated.

---

<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:** [March 4, 2021, 7:51am UTC](https://discuss.elastic.co/t/how-to-convert-miliseconds-into-hhss-using-plainless/263006/5 "2021-03-04T07:51:20Z")

</div>

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