Convert Decimal Hours column to mins

[Qotsa]

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 · Accepted solution]

Hi @Qotsa,

You can create calculated column like this:-

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

[Qotsa]

That was easier than I thought. Thks very much.