Problem with hour cell format

Hello,

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

image

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

image

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

Thank you for your help

Karine

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