# Formato de Hora y Fecha **URL:** \ **Category:** Kibana\ **Created:** [February 15, 2021, 6:37pm UTC](https://discuss.elastic.co/t/formato-de-hora-y-fecha/264346 "2021-02-15T18:37:46Z")\ **Posts on this page:** 3\ **Page:** 1
**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:37pm UTC](https://discuss.elastic.co/t/formato-de-hora-y-fecha/264346/1 "2021-02-15T18:37:46Z")
Hola, soy nueva en Kibana, tengo una Tabla con 2 columnas (fechaini y fechafin) con formato "dd/mm/yyyy hh:mm:ss" . Necesito cambiar este formato a "hh:mm:ss" y luego hacer una resta de estos 2 campos. Por ejemplo: 19:01:00 - 19:00:00 = 1 minuto de diferencia Agradecería que me puedan ayudar. Gracias ![image](https://us1.discourse-cdn.com/elastic/original/3X/1/c/1c43cb0500e967f4a2beb6ed80002d2efab56c1c.png) ---
**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\ **Post date:** [February 16, 2021, 4:55am UTC](https://discuss.elastic.co/t/formato-de-hora-y-fecha/264346/2 "2021-02-16T04:55:44Z")
Welcome to our community! 😃 It's best if you can only create a single topic for your question. I can see you have asked the same thing [here](https://discuss.elastic.co/t/transform-hour-and-date/264347). We also have [language specific categories](https://discuss.elastic.co/c/in-your-native-tongue/11) if that is more comfortable for you 🙂 ---
**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, 4:56am UTC](https://discuss.elastic.co/t/formato-de-hora-y-fecha/264346/3 "2021-03-16T04:56:01Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.