# Como averiguar si un formato hora es pm o am **URL:** \ **Category:** Ask for Help\ **Created:** [August 9, 2024, 1:22pm UTC](https://community.glideapps.com/t/como-averiguar-si-un-formato-hora-es-pm-o-am/75551 "2024-08-09T13:22:01Z")\ **Posts on this page:** 8\ **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 9, 2024, 1:22pm UTC](https://community.glideapps.com/t/como-averiguar-si-un-formato-hora-es-pm-o-am/75551/1 "2024-08-09T13:22:01Z")
Tengo una columna donde tengo la hora, y me gustaria en otra columna determinar si es AM o PM, para ver en que turno está un trabajador. Muchas Gracias de antemano ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [August 9, 2024, 1:33pm UTC](https://community.glideapps.com/t/como-averiguar-si-un-formato-hora-es-pm-o-am/75551/2 "2024-08-09T13:33:17Z")
Can you show me a screenshot of your data table? If you are using a date/time column, then the value will be stored as both a date and a time. ---
**Author:** ![Andreu](https://avatars.discourse-cdn.com/v4/letter/a/ce73a5/32.png) [@Andreu](https://community.glideapps.com/u/Andreu)\ **Post date:** [August 9, 2024, 1:40pm UTC](https://community.glideapps.com/t/como-averiguar-si-un-formato-hora-es-pm-o-am/75551/3 "2024-08-09T13:40:14Z")
![Pantallazo](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/2/52539fffc20280c5735fa1f3d0527f22d17806dc.jpeg) ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [August 9, 2024, 1:42pm UTC](https://community.glideapps.com/t/como-averiguar-si-un-formato-hora-es-pm-o-am/75551/4 "2024-08-09T13:42:32Z")
Okay, so it’s a math column. Can I see the formula please? ---
**Author:** ![Andreu](https://avatars.discourse-cdn.com/v4/letter/a/ce73a5/32.png) [@Andreu](https://community.glideapps.com/u/Andreu)\ **Post date:** [August 9, 2024, 1:51pm UTC](https://community.glideapps.com/t/como-averiguar-si-un-formato-hora-es-pm-o-am/75551/6 "2024-08-09T13:51:59Z")
![Pantallazo-2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/4/c49805e4fb9dd17493316ee83b3b23eb713066a3.jpeg) ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [August 9, 2024, 1:57pm UTC](https://community.glideapps.com/t/como-averiguar-si-un-formato-hora-es-pm-o-am/75551/7 "2024-08-09T13:57:03Z")
Okay, so what you can do is create a second Math column using the following formula: ```auto Hour(Date) ``` Replace `Date` with your “Fecha Entrada” column. This will give you a number representing the hour of the day. Next add an if-then-else column: - If Hour is greater than 11, then PM - Else AM ---
**Author:** ![Andreu](https://avatars.discourse-cdn.com/v4/letter/a/ce73a5/32.png) [@Andreu](https://community.glideapps.com/u/Andreu)\ **Post date:** [August 9, 2024, 2:01pm UTC](https://community.glideapps.com/t/como-averiguar-si-un-formato-hora-es-pm-o-am/75551/8 "2024-08-09T14:01:13Z")
FANTASTICO. Mil Gracias ---
**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 16, 2024, 2:01pm UTC](https://community.glideapps.com/t/como-averiguar-si-un-formato-hora-es-pm-o-am/75551/9 "2024-08-16T14:01:43Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.