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.

​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.  Read More

​