topic Conversion of AM/PM to 24 hrs format in Discussions

Conversion of AM/PM to 24 hrs format

chandankishor66 — Fri, 09 Jun 2023 15:59:10 GMT

Hello JMP user,

Can you please suggest how to convert the time AM/PM to 24 hrs format.

In below table, column 1 is in "Character" Data Type and I want to convert it in 24hrs (h:m:s) format.

Regards,

Chandan

Re: Conversion of AM/PM to 24 hrs format

jthi — Wed, 28 Sep 2022 11:04:35 GMT

If your data is always like that and you just want the hours, I would use formula with Word or Words and then just calculate the values together. One example below:

Num(Word(1, :Column 1)) + If(Word(2, :Column 1) == "PM", 12, 0);

Re: Conversion of AM/PM to 24 hrs format

Jeff_Perkinson — Fri, 30 Sep 2022 20:59:18 GMT

@jthi gave you a good answer for exactly what you were looking to do. However, it's a good practice to use a store times in a time column.

Learn more about how to do that: