Convert AM/PM to 24hour time

Question

Good day All

Please can you help

Data:

Start Time End time7:30 pm8:00 pm11:45 am12:15 pm11:30 pm12:30 am

How do i convert this data so that  to 24 hours

result

Start Time End time19:30:0020:00:0011:45:0012:15:0023:30:0000:30:00

DataNath · Accepted Answer

Hey @Grantham, I'd use a Multi-Field Formula tool here to tackle both fields at the same time. Then we can just use the DateTimeParse() function to handle the incoming times, using their format:

DateTimeParse([_CurrentField_], '%I:%M %p')

More info on how these work here: https://help.alteryx.com/20221/designer/datetime-functions