How to change Time value to Decimal number

[Anonymous]

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?  

[v-gizhi-msft · Accepted solution]

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:

pbix 

Hope this helps.

Best Regards,

Giotto

[amitchandak]

@Anonymous ,Try like a new column

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

[Anonymous]

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

[Anonymous]

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