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
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.
1 Like
Okay, so it’s a math column.
Can I see the formula please?
Okay, so what you can do is create a second Math column using the following formula:
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
1 Like
FANTASTICO. Mil Gracias
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.