Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

converting a number to time/duration

Hey PBI Community,   I'm looking to convert a number into time, but it's not that straight forward.    I have a table that contains 3 columns: 1) Date 2) a value dynamically pulled from an exce...
Need Help
  • Bifinity_75's avatar
    Bifinity_75
    3 years ago

    Sorry I didn't see that you had the value in a calculated column, anyway the procedure is similar:

     

     

Bifinity_75's avatar
Bifinity_75
Icon for Solution Sage rankSolution Sage
3 years ago

Hi sgilmore, try this:

 

In Power Query multiply Time by 0.0416666666666668:

After Transform Column in Hours Format:

 

Result:

 

Best regards