# Formato negativo **URL:** \ **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:** 20\ **Page:** 1
**Author:** ![Andreu](https://avatars.discourse-cdn.com/v4/letter/a/ce73a5/32.png) [@Andreu](https://community.glideapps.com/u/Andreu)\ **Post date:** [August 10, 2024, 4:48pm UTC](https://community.glideapps.com/t/formato-negativo/75581/1 "2024-08-10T16:48:59Z")
Buenas Comunidad, tengo dos columnas con formato hora, una me almacena las horas presencia y la otra, las horas contrato, pues bien quisiera que como resultado diera en negativo cuando las horas jornada fueran menores que las horas contrato…alguna idea? Gracias ---
**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 10, 2024, 5:42pm UTC](https://community.glideapps.com/t/formato-negativo/75581/2 "2024-08-10T17:42:29Z")
Wouldn’t that just be a math column subtracting contract hours from working hours? Or am I not understanding the question? ---
**Author:** ![Andreu](https://avatars.discourse-cdn.com/v4/letter/a/ce73a5/32.png) [@Andreu](https://community.glideapps.com/u/Andreu)\ **Post date:** [August 10, 2024, 5:50pm UTC](https://community.glideapps.com/t/formato-negativo/75581/3 "2024-08-10T17:50:32Z")
Tengo Columna A Horas Contrato: Formato: 08:00:00 y columna B Horas Jornada: : 07:45:00, lo que busco es que en una tercera columna me de: -00:15:00 con el simbolo negativo, cuando las horas sean inferiores. ---
**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 10, 2024, 6:09pm UTC](https://community.glideapps.com/t/formato-negativo/75581/4 "2024-08-10T18:09:56Z")
Same idea though. Wouldn’t you subtract the big number from the small number? How are you trying to calculate it now? When I do it I get a -900. When I feed that into a Format Duration column with mm:ss, I get -15:00. If I use hh:mm:ss I get 00:-15:00 which isn’t ideal, but it has the negative symbol. The other option is to subtract small number from big number which should give you 900. Then feed that into a Format Duration which would give you 00:15:00. Then use a Template column to add the negative symbol. ---
**Author:** ![Andreu](https://avatars.discourse-cdn.com/v4/letter/a/ce73a5/32.png) [@Andreu](https://community.glideapps.com/u/Andreu)\ **Post date:** [August 10, 2024, 6:30pm UTC](https://community.glideapps.com/t/formato-negativo/75581/5 "2024-08-10T18:30:37Z")
Siempre resto la Columna B, que es la que el empleado hace, respecto a la columna A que es la que la empresa marca. ---
**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 10, 2024, 6:54pm UTC](https://community.glideapps.com/t/formato-negativo/75581/6 "2024-08-10T18:54:01Z")
And why can’t you subtract Column A from Column B instead? ---
**Author:** ![Andreu](https://avatars.discourse-cdn.com/v4/letter/a/ce73a5/32.png) [@Andreu](https://community.glideapps.com/u/Andreu)\ **Post date:** [August 10, 2024, 9:04pm UTC](https://community.glideapps.com/t/formato-negativo/75581/7 "2024-08-10T21:04:16Z")
Quiero que cuando haga horas de menos, aparezca en negativo indicandole al empleado las horas de menos que ha trabajado y cuando sea en positivo, pues sin simbolo ---
**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 11, 2024, 12:01am UTC](https://community.glideapps.com/t/formato-negativo/75581/8 "2024-08-11T00:01:59Z")
> [@Jeff\_Hager](#): > > The other option is to subtract small number from big number which should give you 900. Then feed that into a Format Duration which would give you 00:15:00. Then use a Template column to add the negative symbol. Then shouldn’t this work for you @Andreu? ---
**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, 3:54pm UTC](https://community.glideapps.com/t/formato-negativo/75581/10 "2024-08-11T15:54:49Z")
![Pantallazo-3](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/2/42c264ff024f6a952ea25a9b632f45fc6d5a2276.jpeg) ![Pantallazo-4](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/b/bbf5bdaed52756453d71192de020f3682f54d870.jpeg) Algo debo estar haciendo mal…no me funciona ---
**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 11, 2024, 6:12pm UTC](https://community.glideapps.com/t/formato-negativo/75581/11 "2024-08-11T18:12:10Z")
Hola Andreu, déjame ayudar a Thinh y Jeff en este caso usando el castellano como idioma. Imagino que estas 3 fechas/resultados son las incorrectas verdad? ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/a/fad62e183e2fef9d9dbad52cb7ca2b147bcba8b5.jpeg) Tú puedes cambiar el formato de las fechas de las 3 columnas para ver el **Date & Time** del valor en lugar de sólo **Time only**.?. Creo que por allí va el problema, uno de los 2 campos tiene fijado un día de más por encima del otro. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/8/b89abe6762333c2868676de53ca0719b2b48c8b7.png) Gracias, saludos! ---
**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, 7:14pm UTC](https://community.glideapps.com/t/formato-negativo/75581/12 "2024-08-11T19:14:50Z")
I just don’t understand why this isn’t the first step if the result should be negative. There’s other things to potentially clean up afterwards, but if the results should be negative, then the math should be set up correctly to result in a negative. Just my thoughts on it. ![Screenshot_20240811-141200](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/f/3f9ce339d236dd6c56be396e990a085f47100516.jpeg) ---
**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, 7:29pm UTC](https://community.glideapps.com/t/formato-negativo/75581/13 "2024-08-11T19:29:56Z")
Efectivamente, en esos valores es donde se produce el error, cuando la hora es superior me da esos valores… ---
**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, 7:45pm UTC](https://community.glideapps.com/t/formato-negativo/75581/14 "2024-08-11T19:45:45Z")
No funciona con tu propuesta ---
**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, 7:57pm UTC](https://community.glideapps.com/t/formato-negativo/75581/15 "2024-08-11T19:57:19Z")
Las horas de contrato las voy a buscar de las especificaciones de cada empleado,. La presencia, es la diferencia entre la entrada y salida de trabajo, y la diferencia es el campo que resta entre HORAS CONTRATO Y PRESENCIA ---
**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 11, 2024, 8:13pm UTC](https://community.glideapps.com/t/formato-negativo/75581/16 "2024-08-11T20:13:11Z")
Muestréame por favor una imagen de las 3 columnas usando el formato de salida **Date & Time** en el calculo. Gracias! ---
**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:21pm UTC](https://community.glideapps.com/t/formato-negativo/75581/17 "2024-08-11T20:21:50Z")
> [@Andreu](#): > > pues bien quisiera que como resultado diera en negativo cuando las horas jornada fueran menores que las horas contrato 🤷‍♂️ ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/e/fec1bbd5f40f95330efa900564ac4fe01f2974cc.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/7/b7256d3216be4202de4ffc5d3b72cad2794e2fa4.png) ---
**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:24pm UTC](https://community.glideapps.com/t/formato-negativo/75581/18 "2024-08-11T20:24:16Z")
La diferencia que yo observo respecto a tu solución es que mis HORAS DE CONTRATO son un Rollup de busqueda… como te adjunto. ![HORA-1](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/2/c2b11e177b68e50cc322f36a79e1a234632b74dc.jpeg) ![HORA-2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/d/3d796d3b9951ae527822d07355e067c3cf9adf59.jpeg) ![HORA-3](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/f/6f28a65e0d5279427c2a9ccf0ce6d70728cab3e2.jpeg) ![HORA-4](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/f/bfdfd186024443ce6cbc834585dc044107c78ee7.jpeg) ![HORA-5](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/e/be63793898818e41a8d8e5722aec11c01c06eda5.jpeg) ---
**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:36pm UTC](https://community.glideapps.com/t/formato-negativo/75581/19 "2024-08-11T20:36:26Z")
Your Horas Contrato Lookup refers to a date column (Horas). How is the Horas column in the other table filled? ---
**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:39pm UTC](https://community.glideapps.com/t/formato-negativo/75581/20 "2024-08-11T20:39:04Z")
Si, te adjunto el formato ![HORA-6](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/b/cb7d9245dd88dd517c73753618eeb80985e398d2.jpeg) ---
**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:43pm UTC](https://community.glideapps.com/t/formato-negativo/75581/21 "2024-08-11T20:43:10Z")
How do you fill it though? It’s a date column, so it’s going to have an underlying date along with the time. [Next page](https://community.glideapps.com/t/formato-negativo/75581.md?page=2)