convert duration into decimal

[vrypel]

Hello, I'm trying to convert durations expressed for example as 43:06, 256:08, 6:25 into hours and portion of hours (43.1, 256.1, 6.3).  Try as I have, I can not seem to find a formula that does this, nor can I seem to be able to determine what the format of the column containing the values should be (I tried [h]:mm, but that doesn't seem to work).  I'm thinking I need to extract the hours value and then just multiply the minutes by 60, and format the new column as a number with 1 decimal but that gives incorrect responses.  Any help would be appreciated.

[#2]

@vrypel 

Durations, like all dates and times in Excel, are measured in days.  To convert to hours just multiply by 24 and adjust the number format,

= 24 * duration

[#3]

Thank you @PeterBartholomew1.  I think the problem was I had formatted the column with the durations into [h]:mmm and by simply changing the column format to "general", I was able to apply the formula you suggested and do the conversions.  Works great!  Thanks!