Problem with hour cell format


This Excel format : 06/01/1900 02:00:10 is the format of the cell but the visual is the picture below


When I import the data in Easymorph, it also changes the data.


How can I get the visual format : 146:00 in Easymorph ?

Thank you for your help


It’s not possible to have visual format like 146:00 for numbers in EasyMorph. However you can create an additional column with text values created using the expression below:

astext(floor([Column] * 24)) & ":" & format([Column], 'mm')

To understand better how numbers are used to represent dates and times in EasyMorph see this tutorial article: