Converting Military Time Format (hhmm) to Time Format (hh:mm)
May 13, 2016 02:32 AM(24532 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.