Skip to main content
cancel
Showing results for
Search instead for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Advocate I

## How to change Time value to Decimal number

In a column I have values

8.00.00

2.30.00

4.45.00

which are Time Type. I need to change them to Decimal Numbers so they would be

8,00

2,50

4,75

How can I achieve this?

1 ACCEPTED SOLUTION
Community Support

Hi,

According to your description, i create a sample like this:

After Apply&Close, it shows:

Then try this calculated column:

``TimeDuration = 'Table'[Custom]*24``

The result shows:

Here is my test pbix file:

Hope this helps.

Best Regards,

Giotto

4 REPLIES 4
Community Support

Hi,

According to your description, i create a sample like this:

After Apply&Close, it shows:

Then try this calculated column:

``TimeDuration = 'Table'[Custom]*24``

The result shows:

Here is my test pbix file:

Hope this helps.

Best Regards,

Giotto

Super User

@Finnair ,Try like a new column

New column = hour([Time]) + Minute([Time])/60

Advocate I

No, my time values are in fact durations, so your suggestion is not ok. Thanks anyway.

Anonymous
Not applicable
Try something like below

Time=hour(table[time])+(minute(table[time])/60)

If you are facing any issue related to type use format function to convert it into appropriate one
Thanks
Pravin

## Helpful resources

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors