Convert AM/PM to 24hour time

[Grantham]

Good day All 

Please can you help 

Data: 

Start Time	End time
7:30 pm	8:00 pm
11:45 am	12:15 pm
11:30 pm	12:30 am

How do i convert this data so that  to 24 hours

result 

Start Time	End time
19:30:00	20:00:00
11:45:00	12:15:00
23:30:00	00:30:00

[DataNath · Accepted solution]

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