Duration as Text - Convert to Hours & Minutes

[Qotsa]

Hi,

I have a column NoofHours stored as text format. 01:30:00 is 1 hr 30 minutes. How do i convert to 90 minutes.

If I use Calc column

= MINUTE(StdWeekDay[NoofHours]) I get 30. It leaves out the 1 hr.

Storage Mode is Direct Query.

[Anonymous]

Hi @Qotsa 
One option is 

NoofHours in minutes = 
var hours = MID(Table1[NoofHours],1,2)
var minutes = MID(Table1[NoofHours],4,2)

return hours*60 + minutes

minute function returns values between 0 and 59 only.

Good luck!

[parry2k]

@Qotsa you can also take advantage of duration function in Power Query.

Goto query editor and add new custom column with following formula

Duration.TotalMinutes(Duration.FromText([NoofHours]))

[Anonymous · Accepted solution]

@Qotsa - You could do 

= MINUTE(StdWeekDay[NoofHours]) + (HOUR(StdWeekDay[NoofHours]) * 60)

Cheers!

Nathan