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 |
Solved! Go to 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