AnsweredAssumed Answered

Import from excel, time field

Question asked by ahlinterest on Feb 3, 2017
Latest reply on Feb 10, 2017 by ahlinterest



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!