Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Convert Decimal Hours column to mins

Hi,

 

I have a column duration from an SQL DB. It's in decimal number containing .25,.75, .5 etc..

I'd like to convert all these to minutes

 

Need the whole column to display as 15,45,30 etc...

Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi Anonymous,

    You can create calculated column like this:-

    Converted to Minutes = 'Time'[Duration]*60
     

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Anonymous,

    You can create calculated column like this:-

    Converted to Minutes = 'Time'[Duration]*60
     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      That was easier than I thought. Thks very much.