# Formato negativo

**URL:** <https://community.glideapps.com/t/formato-negativo/75581>\
**Category:** General\
**Created:** [August 10, 2024, 4:48pm UTC](https://community.glideapps.com/t/formato-negativo/75581 "2024-08-10T16:48:59Z")\
**Posts on this page:** 7\
**Page:** 2

<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 11, 2024, 8:47pm UTC](https://community.glideapps.com/t/formato-negativo/75581/22 "2024-08-11T20:47:30Z")

</div>

Solo se completa con la Hora de forma manual, ya que los turnos no tienen que ver con las fechas, si no con las horas por jornada, por eso la entrada es de forma manual y personalizada por cada empleado…

---

<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 11, 2024, 8:49pm UTC](https://community.glideapps.com/t/formato-negativo/75581/23 "2024-08-11T20:49:12Z")

</div>

Tal vez el error es que no debería ser formato hora?

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [August 11, 2024, 8:52pm UTC](https://community.glideapps.com/t/formato-negativo/75581/24 "2024-08-11T20:52:25Z")

</div>

Change the format of Horas to include the date. I want to see what the actual date is for that column instead of just the time.

---

<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 11, 2024, 8:58pm UTC](https://community.glideapps.com/t/formato-negativo/75581/25 "2024-08-11T20:58:17Z")

</div>

Guarda la fecha en la que di de alta todos los horarios

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

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [August 11, 2024, 9:12pm UTC](https://community.glideapps.com/t/formato-negativo/75581/26 "2024-08-11T21:12:49Z")

</div>

I’d probably approach it differently since you are trying to store a duration in a column that is meant to hold a date and time…but without trying to change too much in your app, try this in your Diferencia math column. It will take the Lookup Horas, find the duration from midnight of the day you registered the schedule (which should result in a duration of just the hours and match your contract time), and then subtract that result from Presencia.

`p-(d-(d-(hour(d)/24+minute(d)/1440+second(d)/86400)))`

---

<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 11, 2024, 9:17pm UTC](https://community.glideapps.com/t/formato-negativo/75581/27 "2024-08-11T21:17:55Z")

</div>

> [@Jeff\_Hager](#):
>
> p-(d-(d-(hour(d)/24+minute(d)/1440+second(d)/86400)))

F A N T A S T I C O …Ha funcionado correctamente. Muchas gracias por tu paciencia y tiempo.

---

<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 18, 2024, 9:18pm UTC](https://community.glideapps.com/t/formato-negativo/75581/28 "2024-08-18T21:18:07Z")

</div>

Closed on August 18, 2024, 9:18pm UTC

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

[Previous page](https://community.glideapps.com/t/formato-negativo/75581.md?page=1)