# Convertir un nombre en temps dans le data

**URL:** <https://community.glideapps.com/t/convertir-un-nombre-en-temps-dans-le-data/41725>\
**Category:** Ask for Help\
**Created:** [May 7, 2022, 8:29am UTC](https://community.glideapps.com/t/convertir-un-nombre-en-temps-dans-le-data/41725 "2022-05-07T08:29:45Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![aklapka](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/aklapka/32/1103_2.png) [@aklapka](https://community.glideapps.com/u/aklapka)\
**Post date:** [May 7, 2022, 8:29am UTC](https://community.glideapps.com/t/convertir-un-nombre-en-temps-dans-le-data/41725/1 "2022-05-07T08:29:45Z")

</div>

Bonjour,  
Je voudrais rapidement convertir un nombre en un temps.  
ex: 128 en 00:02:08 dans le data.  
J’y arrive mais il faut rajouter quelques colonnes. Comment faire la conversion rapidement?  
Merci d’avance.  
Aurélien

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [May 7, 2022, 11:09pm UTC](https://community.glideapps.com/t/convertir-un-nombre-en-temps-dans-le-data/41725/2 "2022-05-07T23:09:59Z")

</div>

So you have the number 128 and want to do a conversion to a duration format like 00:02:08?

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/c/7cce050454a27cbb4ee99170e7cd51f76edd7baa.jpeg)

Use this JavaScript snippet.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/b/cb5a29ee2a2421064f12bd87baa98ae0185a337d.jpeg)

```auto
return new Date(1000 * p1).toISOString().substr(11, 8)

```