cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Browse apps to extend the software in the new JMP Marketplace
Choose Language Hide Translation Bar
nadershakerin0
nadershakerin0
Level II

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

May 13, 2016 02:32 AM (25461 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
ms
Super User (Alumni) ms
Super User (Alumni)

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

Created: May 14, 2016 09:31 PM  |  Last Modified: Jan 27, 2021 11:06 AM (19649 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 )
);

 

khoepfl
khoepfl
Level I

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

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

How about converting from Military Time to regular?

0 Kudos