Discussions

Solve problems, and share tips and tricks with other JMP users.

Level II

May 13, 2016 02:32 AM (31571 views)

I need to convert military time in the hhmm format, e.g. 1432 or 725 to hh:mm format e.g. 14:32 to 7:25. Is there a simple formula that can make the conversion, or should I use a script for it? Thanks.

11 REPLIES 11

Super User (Alumni)

Created: May 14, 2016 09:31 PM | Last Modified: Jan 27, 2021 11:06 AM (20433 views) | Posted in reply to message from nadershakerin0 05-13-2016

Still another approach that avoids strings altogether:

dt << New Column( "time",
    Numeric,
    "Continuous",
    Format( "hr:m", 12 ),
    Formula( Floor( :Military / 100 ) * 3600 + Mod( :Military, 100 ) * 60 )
);

Level I

Jan 5, 2017 01:51 PM (20144 views) | Posted in reply to message from ms 05-14-2016

How about converting from Military Time to regular?

Discussions

Converting Military Time Format (hhmm) to Time Format (hh:mm)

Re: Converting Military Time Format (hhhh) to Time Format (hh:mm)

Re: Converting Military Time Format (hhhh) to Time Format (hh:mm)

Recommended Articles