Skip to main content

Hi! Trying to figure out how to make a field that turns these times into a 24hr format. I’ve tried 2 different time formats examples (01:00 PM - 7:30 PM) as well as (3-8 PM). I’m have a hard time figuring out a formula that will display that in a 24hr format? Any ideas? 

How does this look?

DATETIME_FORMAT(
  DATETIME_PARSE(
    TRIM(LEFT({Text field}, FIND("-", {Text field}) - 1)),
    "h:mm A"
  ),
  "HH:mm"
)
&' - '&
DATETIME_FORMAT(
  DATETIME_PARSE(
    TRIM(
      SUBSTITUTE(
        {Text field},
        LEFT({Text field}, FIND("-", {Text field})),
        ""
      )
    ),
    "h:mm A"
  ),
  "HH:mm"
)

 

Returning an #error

Could you provide a screenshot of your table please?

Terms & ConditionsAccessibility statement