Convert 24 hour format to 12 hour format?

[ricky10ss]

Hello,

 

Does anyone know a rule that can convert 24 hour time that I have in a spreadsheet to 12 hour time? Example 830 should be 8:30 AM and 1830 should be 6:30 PM

 

Thanks in advance of any help.

 

Using Windows XP and 7 with FusionPro 8.0.20.

[Dan Korn]

A Google search for "javascript parse 24-hour time" returns several results.

 

This one seems to work for me:

http://stackoverflow.com/a/3998370

 

You can just copy that code into your rule, or into your JavaScript Globals, and then do this:

return FormatDate(parseTime(Field("YourFieldName")), "h:nn A");

However, for a more robust solution, I would bring in the Date.js library for anything like this. You can download the file and either put it in your Plug-ins folder [C:\Program Files (x86)\PTI\FusionPro\Plug-ins], or copy-and-paste the entire contents into your JavaScript Globals. Then you can create a rule as simple as this:

return Date.parseExact(Field("YourFieldName"), ["HHmm", "Hmm"]).toString("h:mm tt");

[ricky10ss]

Thank you very much. That did the trick.