Forum Discussion

vrypel's avatar
vrypel
Copper Contributor
Sep 24, 2024

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.

  • 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

     

    • vrypel's avatar
      vrypel
      Copper 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! 

Resources