Formatting time by hour

[nujkram]

Good day everyone, I have here a chart where the x axis represents the time by decimal (hour).(minute)

Is it possible to format it as time? Example 14.0 = 14:00 or 02:00PM

[Birdjo · Accepted solution]

Hello @nujkram,

Here's how you can solve this very simply.

Firstly create a new column by concatenating ":00:00" to you the whole number representing the time.:

Time = CONCATENATE(Table1[NumTime]; ":00:00")

Then go to the modeling tab and change the data type to time,

then the format to 13:30 (HH:mm)

I hope this solves your issue!

[nujkram]

Thank you @Birdjo, works perfectly!