# Restar horas de numeros

**URL:** <https://community.glideapps.com/t/restar-horas-de-numeros/75628>\
**Category:** Ask for Help\
**Created:** [August 13, 2024, 7:40pm UTC](https://community.glideapps.com/t/restar-horas-de-numeros/75628 "2024-08-13T19:40:21Z")\
**Posts on this page:** 16\
**Page:** 1

<div class="post-metadata">

**Author:** ![Andreu](https://avatars.discourse-cdn.com/v4/letter/a/ce73a5/32.png) [@Andreu](https://community.glideapps.com/u/Andreu)\
**Post date:** [August 13, 2024, 7:40pm UTC](https://community.glideapps.com/t/restar-horas-de-numeros/75628/1 "2024-08-13T19:40:21Z")

</div>

Buenas comunidad, alguien me puede ayudar a indicarme como restar una columna con formato número donde indico que un empleado tiene 40 horas a la semana, y otra columna con formato hora, donde indico las horas realizadas. Adjunto los pantallazos  
 ![HorasContrato](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/2/424e6d301f1886eb6ff153c4d868a11a05b17de2.jpeg)  
 ![HorasContratoRealizadas](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/2/b27bba8951a547a3cc14477984be70fecf465375.jpeg)

---

<div class="post-metadata">

**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\
**Post date:** [August 13, 2024, 11:18pm UTC](https://community.glideapps.com/t/restar-horas-de-numeros/75628/2 "2024-08-13T23:18:51Z")

</div>

Hola otra vez!

La clave es convertir los Tiempos Trabajados ( **Duración** ) en horas para tener la misma unidad de tiempo de las Horas Semanales estimadas.

Algo como esto creo quieres tener  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/0/d0413ad6501620f215df0c76d954f23efaa1f30e.png)

y la ecuación a tener para lograr que tu **Duración** esté en horas debería lucir así  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/c/3c230bbb805a87e4542a2b1973b42dca0a33638c.png)

Espero te sirva, suerte!

---

<div class="post-metadata">

**Author:** ![Andreu](https://avatars.discourse-cdn.com/v4/letter/a/ce73a5/32.png) [@Andreu](https://community.glideapps.com/u/Andreu)\
**Post date:** [August 14, 2024, 8:28am UTC](https://community.glideapps.com/t/restar-horas-de-numeros/75628/3 "2024-08-14T08:28:03Z")

</div>

Muchas Gracias, me ha servido de forma genial…solo un asunto mas si eres tan amable, como puedo pasar ese resultado de la direrencia a un formato hora comprensible por el usuario, me explico con este pantallazo que te adjunto  
 ![HORASFINALES](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/3/c3b578c4c951d8256529b489c3d2e54b6b8da03e.jpeg)  
Muchas Gracias

---

<div class="post-metadata">

**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\
**Post date:** [August 14, 2024, 2:16pm UTC](https://community.glideapps.com/t/restar-horas-de-numeros/75628/4 "2024-08-14T14:16:28Z")

</div>

Ok!

Intenta con este código JS para tener el formato HH:MM que quieres

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/7/17e6668079bde4aca6404226139385b5b668010d.png)

```auto
let hora= Math.trunc(p1);
let horaDec = Math.trunc((p1-hora)*60);
let cero= "" ;
if (horaDec ==0)
    cero="0"

return hora + ":" + horaDec+ "" + cero

```

Saludos!

---

<div class="post-metadata">

**Author:** ![Andreu](https://avatars.discourse-cdn.com/v4/letter/a/ce73a5/32.png) [@Andreu](https://community.glideapps.com/u/Andreu)\
**Post date:** [August 14, 2024, 2:51pm UTC](https://community.glideapps.com/t/restar-horas-de-numeros/75628/6 "2024-08-14T14:51:14Z")

</div>

Funciono correctamente, un error de escritura por mi parte. Muchas gracias por tu inestimable ayuda. Un abrazo

---

<div class="post-metadata">

**Author:** ![Andreu](https://avatars.discourse-cdn.com/v4/letter/a/ce73a5/32.png) [@Andreu](https://community.glideapps.com/u/Andreu)\
**Post date:** [August 14, 2024, 2:57pm UTC](https://community.glideapps.com/t/restar-horas-de-numeros/75628/7 "2024-08-14T14:57:54Z")

</div>

> [@gvalero](#):
>
> ```auto
> let hora= Math.trunc(p1);
> let horaDec = Math.trunc((p1-hora)*60);
> let cero= "" ;
> if (horaDec ==0)
> cero="0"
> 
> return hora + ":" + horaDec+ "" + cero
> 
> ```

Seria la bomba que tambien me aparecieran los segundos…disculpa que abuse de tu conocimiento

---

<div class="post-metadata">

**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\
**Post date:** [August 14, 2024, 3:59pm UTC](https://community.glideapps.com/t/restar-horas-de-numeros/75628/8 "2024-08-14T15:59:01Z")

</div>

Jeje…  
Déjame terminar un asunto y armamos esa bomba!

---

<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:** [August 14, 2024, 11:39pm UTC](https://community.glideapps.com/t/restar-horas-de-numeros/75628/9 "2024-08-14T23:39:12Z")

</div>

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/0/30b17ad217efd207a6e6f3ec962774860a65f732.png)

You can convert your difference to seconds and use this column.

---

<div class="post-metadata">

**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\
**Post date:** [August 15, 2024, 2:35pm UTC](https://community.glideapps.com/t/restar-horas-de-numeros/75628/10 "2024-08-15T14:35:29Z")

</div>

> [@ThinhDinh](#):
>
> ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/0/30b17ad217efd207a6e6f3ec962774860a65f732.png)
> 
> image913×436 44.3 KB

WTF!! 🤣

I confused the plugin when I was looking for the right one and I thought it couldn’t be done using a plugin… 🥴

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/7/d723d92f0e1ad40d710b9f6092092c54ae91c951.png)  
Thanks @ThinhDinh

@Andreu, usa el _Format Duration_ plugin para lograr el formato que te falta, es más fácil de usar que el código JS que te di antes. Disculpa.

Saludos!

---

<div class="post-metadata">

**Author:** ![Andreu](https://avatars.discourse-cdn.com/v4/letter/a/ce73a5/32.png) [@Andreu](https://community.glideapps.com/u/Andreu)\
**Post date:** [August 15, 2024, 3:32pm UTC](https://community.glideapps.com/t/restar-horas-de-numeros/75628/11 "2024-08-15T15:32:55Z")

</div>

Creo que no estoy siendo capaz de transformar la ultima columna en 25:42:54 que es lo que tendría que ser:

 ![NOCAPAZ](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/2/b2da5b9d2a067f7b77246ce8579eaddb4ec93ce2.jpeg)

---

<div class="post-metadata">

**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\
**Post date:** [August 15, 2024, 4:12pm UTC](https://community.glideapps.com/t/restar-horas-de-numeros/75628/12 "2024-08-15T16:12:02Z")

</div>

Tienes que convertir las Horas Restantes en segundos (x 3600) y ese valor es el que usarás en el plugin.

El Plugin sólo trabaja con Segundos para darte el formato deseado.

---

<div class="post-metadata">

**Author:** ![Andreu](https://avatars.discourse-cdn.com/v4/letter/a/ce73a5/32.png) [@Andreu](https://community.glideapps.com/u/Andreu)\
**Post date:** [August 15, 2024, 4:46pm UTC](https://community.glideapps.com/t/restar-horas-de-numeros/75628/13 "2024-08-15T16:46:59Z")

</div>

Disculpa mi ignorancia, pero no soy capaz de ver o entender lo que me indicas. Gracias por tu paciencia

---

<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:** [August 15, 2024, 11:49pm UTC](https://community.glideapps.com/t/restar-horas-de-numeros/75628/14 "2024-08-15T23:49:59Z")

</div>

You have to add a math column first to convert your difference to seconds. Then use that seconds result to convert to duration using the “Format Duration” column.

---

<div class="post-metadata">

**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\
**Post date:** [August 16, 2024, 2:54pm UTC](https://community.glideapps.com/t/restar-horas-de-numeros/75628/15 "2024-08-16T14:54:40Z")

</div>

Hola Andreu,

Disculpa el retraso. Aquí el paso a paso para lograr esto:

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/6/a677fa899b538417bdb7e8d6d3f27027289241d8.png)

**Paso 1**

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/7/8735a203f35931cc8cfd2c5457e012ed9150ae19.png)

**Paso 2**

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/7/47f2883e4d23a599c80f92658e4c65f81c64f34d.png)

Feliz fin de semana!

---

<div class="post-metadata">

**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\
**Post date:** [August 19, 2024, 4:50pm UTC](https://community.glideapps.com/t/restar-horas-de-numeros/75628/16 "2024-08-19T16:50:37Z")

</div>

@Andreu te sirvió la solución y la implementaste?

Si es así, marca tu pregunta como solucionada para cerrar el caso y ayudar al sistema a ser más eficiente.

Saludos!

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [August 26, 2024, 4:51pm UTC](https://community.glideapps.com/t/restar-horas-de-numeros/75628/17 "2024-08-26T16:51:34Z")

</div>

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