cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Qotsa Regular Visitor
Regular Visitor

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...

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Convert Decimal Hours column to mins

Hi @Qotsa,

You can create calculated column like this:-

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

Duration.JPG

2 REPLIES 2

Re: Convert Decimal Hours column to mins

Hi @Qotsa,

You can create calculated column like this:-

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

Duration.JPG

Qotsa Regular Visitor
Regular Visitor

Re: Convert Decimal Hours column to mins

That was easier than I thought. Thks very much.