2 Replies Latest reply: May 15, 2014 10:13 AM by Olly Bond RSS

    Monarch v11.2: Need Native Military Time Format: HH:MM

    Bruce Chitiea

      What Am I Missing Department:

       

      Would really like, kinda need, the HH:MM time format.

       

      An Excel Time column formatted as hh:mm imports as 12/30/1899 hh:mm:ss XM . The is of what usefulness in a time column?

       

      The field properties, when reset to "Date/Time" "Time" give hh:mm:ss XM .

       

      I can concatenate the results of two calculated columns and to produce HH:MM in a calculated text column.

       

      Seems like HH:MM, being an international standard and all, should be built in as a time format.

       

      Thoughts, anyone?

      Bruce Chitiea