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]

How do you get on with this? Have included both options; formula and DateTime tools.

[Tessa_Gable]

The input tool is bringing the data in as 16:00:00.000Z.  These are store hours so I need the output to be 4:00.  I've not seen this format before, 16:00:00.000Z.

[DataNath · Accepted solution]

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.