How to convert this data to be in time format HH:MM with AM/PM

[aanmi]

Hi

I have a data which I import from Dynamics 365 (D365).

There's a column for Start Time with integer value. I already changed the data type (from Whole Number to Time) and Format (from Whole number to HH:MM) but it's not working. It will show all rows convert to 12:00:00 AM. Please advise

[MrSujay · Accepted solution]

Create a new calculated column with the below Dax formula :

Time = FORMAT( [CorrectedStartTime] / 60 / 60 /24, "hh:nn:ss" )

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[aanmi]

MrSujay

Thank you so much for your help. It's working just what I want.  😀