Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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?  

Need Help
  • v-gizhi-msft's avatar
    v-gizhi-msft
    6 years ago

    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

4 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    Anonymous ,Try like a new column

     

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

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

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago
        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
  • v-gizhi-msft's avatar
    v-gizhi-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    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