cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
nujkram Frequent Visitor
Frequent Visitor

Formatting time by hour

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

time-format.jpg

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Birdjo Member
Member

Re: Formatting time by hour

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)

image.png

 

I hope this solves your issue!

2 REPLIES 2
Highlighted
Birdjo Member
Member

Re: Formatting time by hour

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)

image.png

 

I hope this solves your issue!

nujkram Frequent Visitor
Frequent Visitor

Re: Formatting time by hour

Thank you @Birdjo, works perfectly!