4 Replies Latest reply on Feb 10, 2017 6:58 AM by ahlinterest

    Import from excel, time field

    ahlinterest

      Hi!

       

      Can any one tell me what cell settings in excel file  to use to obtain the result in mmss (minute second  ex. 22.30) when imported into FM field.

       

      Also what settings it should be in the FM field.

      I have tried time, date, number text... everything. Gets results ex 1900 01.....Wondering if it is possible

       

      The field is used for simple calculation.

       

      Thanks for answer!

       

      ahlinterest