799563_en-US

liliconcom

Converting Military Time to h:m:s format

Hi - I am trying to convert a column with military time in character format (e.g. 130749 ) to h:m:s format in jsl. Can someone please help?Thanks.

 

 

Automation and ScriptingRe: Converting Military Time to h:m:s format

Informat + Format pattern is one option

Names Default To Here(1);
Informat("130749", "Format Pattern", "<HH24><MM><SS>");


:0:13:07:49;
:0:13:07:49 + 0; // 47269

// Seconds since JMP's time start (midnight January 1, 1904)
// https://www.jmp.com/support/help/en/18.0/index.shtml#page/jmp/date-and-time-functions.shtml</SS></MM></HH24>

Re: Converting Military Time to h:m:s format

So I'm actually looking to convert the military time to h:m:s AM/PM format. So for example, 130749 would be 1:07:49 PM. Is this possible?

Re: Converting Military Time to h:m:s format

You can convert that datetime to whatever you wish to. I assume you want it back to a string in which case you can for example use Format + Format Pattern

Names Default To Here(1);

Format(Informat("130749", "Format Pattern", "<HH24><MM><SS>"), "Format Pattern", "<HH>:<MM>:<SS> <AMPM>"); // "1:07:49 PM"</AMPM></SS></MM></HH></SS></MM></HH24>

 

Re: Converting Military Time to h:m:s format

Is format pattern only available starting with JMP16? I have JMP 15. 

Re: Converting Military Time to h:m:s format

I don't remember when it was introduced, either in JMP16 or 17. You can maybe still do it with Informat/Format but I'm not sure how as time handling was clunky in JMP before format pattern (and it still is due to how it handles different time formats on different machines with different settings). So I would build it from parts, this might work

Names Default To Here(1);

template = "^hh12^:^mm^:^ss^ ^ampm^";

str = "130749";

hh24 = Num(Left(str, 2));
mm = Substr(str, 3, 2);
ss = Right(str, 2);

ampm = "";
If(hh24 == 0,
	hh12 = 12;
	ampm = "AM";
, 12 <= hh24 <= 23,
	hh12 = Mod(hh24, 12);
	ampm = "PM"
,
	ampm = "AM";
	hh12 = hh24;
);

timestr = Eval Insert(template);

Re: Converting Military Time to h:m:s format

Thank you!