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...
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
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!
