topic Re: Converting Military Time to h:m:s format in Discussions

Converting Military Time to h:m:s format

dn610 — Tue, 17 Sep 2024 13:41:41 GMT

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.

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

jthi — Tue, 17 Sep 2024 14:23:16 GMT

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

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

dn610 — Tue, 17 Sep 2024 18:40:46 GMT

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

jthi — Tue, 17 Sep 2024 18:53:12 GMT

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"

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

dn610 — Tue, 17 Sep 2024 20:18:30 GMT

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

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

jthi — Wed, 18 Sep 2024 04:27:53 GMT

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

dn610 — Wed, 18 Sep 2024 16:14:09 GMT

Thank you!