Converting to 24 Hour time format

Morning all,

A bit of a sticky one here - I've got a string field I'd like to convert to Date in 24 hour format.

The data looks like this:

I've started by using the DateTime Parse tool, which looks as though it has worked fine, now I need to write a formula that will take the AM/PM field and convert the Time into 24 hours accordingly.

Can anyone please help?

Thanks

Accepted answers

Jonathan-Sherman

Hi @Blondek,

Could you check your data type is a Time and not a DateTime? It's likely that's the issue. If it isn't you may need to use a select tool to change it to a Time data type.

If this solves your issue please mark the answer as correct, if not let me know!

Regards,

Jonathan

All comments

Jonathan-Sherman

Hi @Blondek,

Do you want to combine the data and time into a datetime value (with time in 24 hour format) or leave date and time separate (as they currently are, just with time in 24 hour format?)