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: https://easymorph.com/learn/expressions.html