Como averiguar si un formato hora es pm o am

Ask for Help
7

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