Forum Discussion

nujkram's avatar
nujkram
Regular Visitor
8 years ago
Solved

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
Need Help
  • Birdjo's avatar
    Birdjo
    8 years ago

    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!

Birdjo's avatar
Birdjo
Resolver II
8 years ago

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's avatar
    nujkram
    Regular Visitor
    8 years ago

    Thank you Birdjo, works perfectly!