Forum Discussion
convert duration into decimal
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.
- PeterBartholomew1Silver Contributor
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
- vrypelCopper Contributor
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!