# Transform Hour and date

**URL:** <https://discuss.elastic.co/t/transform-hour-and-date/264347>\
**Category:** Kibana\
**Created:** [February 15, 2021, 6:40pm UTC](https://discuss.elastic.co/t/transform-hour-and-date/264347 "2021-02-15T18:40:25Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jelssy\_Pomar\_Alvan](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jelssy_pomar_alvan/32/83941_2.png) [@Jelssy\_Pomar\_Alvan](https://discuss.elastic.co/u/Jelssy_Pomar_Alvan)\
**Post date:** [February 15, 2021, 6:40pm UTC](https://discuss.elastic.co/t/transform-hour-and-date/264347/1 "2021-02-15T18:40:25Z")

</div>

Hello, I am new to Kibana, I have a Table with 2 columns (dateini and date end) with format "dd / mm / yyyy hh: mm: ss". I need to change this format to "hh: mm: ss" and then do a subtraction of these 2 fields and display them in a metric.

For example: 19:01:00 - 19:00:00 = 1 minute difference

I would appreciate if you can help me.

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/1/c/1c43cb0500e967f4a2beb6ed80002d2efab56c1c.png)

---

<div class="post-metadata">

**Author:** ![AClerk](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/aclerk/32/55297_2.png) [@AClerk](https://discuss.elastic.co/u/AClerk)\
**Post date:** [February 16, 2021, 4:27am UTC](https://discuss.elastic.co/t/transform-hour-and-date/264347/2 "2021-02-16T04:27:45Z")

</div>

You can create a [scripted field](https://www.elastic.co/blog/using-painless-kibana-scripted-fields).

```auto
int start = doc['date_filed1'].value.getHour()*3600 + doc['date_filed1'].value.getMinute()*60 + doc['date_filed1'].value.getSecond();
int end = doc['date_filed2'].value.getHour()*3600 + doc['date_filed2'].value.getMinute()*60 + doc['date_filed2'].value.getSecond();
int diff = end-start;
return diff;

```

This will give you the differences in seconds.

Thanks!

---

<div class="post-metadata">

**Author:** ![Jelssy\_Pomar\_Alvan](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jelssy_pomar_alvan/32/83941_2.png) [@Jelssy\_Pomar\_Alvan](https://discuss.elastic.co/u/Jelssy_Pomar_Alvan)\
**Post date:** [February 16, 2021, 5:06am UTC](https://discuss.elastic.co/t/transform-hour-and-date/264347/3 "2021-02-16T05:06:00Z")

</div>

Thanks, but my initial field is a string, how to convert my initial field to a date?

---

<div class="post-metadata">

**Author:** ![AClerk](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/aclerk/32/55297_2.png) [@AClerk](https://discuss.elastic.co/u/AClerk)\
**Post date:** [February 16, 2021, 5:13am UTC](https://discuss.elastic.co/t/transform-hour-and-date/264347/4 "2021-02-16T05:13:39Z")

</div>

There are examples in the documentation.  
Please [read it](https://www.elastic.co/guide/en/elasticsearch/painless/master/painless-datetime.html).

---

<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 16, 2021, 5:14am UTC](https://discuss.elastic.co/t/transform-hour-and-date/264347/5 "2021-03-16T05:14:01Z")

</div>

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