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