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...
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi Anonymous,

    You can create calculated column like this:-

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