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?
Question
Convert 12 hour time - time frame to 24hr
+2
+31How 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"
)
+31Could you provide a screenshot of your table please?
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.