cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

## 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

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