Change from Militarty time to standard

Tessa_Gable

I am importing data from a table in SQL server.  The origins of this data in SQL server is Salesforce and is formatted as this: (Time)

However, I tried the datetime tool I've also tried parse but can't get this into a normal standard time of 4:00.  

I've tried the date time tool

Any suggestions would be appreciated :-)

DataNath

Have updated the workflow. Does this work? If not let me know and let me know if it's fine to parse the incoming time to hh:mm first, too.

In terms of the format, Iirc, the 000Z is just an indicator as to how much the time needs to be offset against UTC. In this case it's 0.

EDIT: If you want the time in 12 hour with/without the am/pm indicators then you can use the equations in this formula tool as you see fit.

Military time conversion.yxmd