Trying to organize a timesheet. I have a cell with a duration of, say, 84:30:00 (84 hours, 30 mins, 0 seconds), which has a number format of "Duration".

How can I calculate the decimal number of hours (84.5) from this? The obvious approaches Hour(), Value() don't seem to work...


Oh, you just multiply by 24 then format as a number. I guess durations are numerically stored as the number of days. Simple.

  • 2
    Very useful answer. But what a guess..! – Mohammed Shareef C Jun 11 '19 at 16:23
  • The guess was super helpful! Thanks! – Mohammad Arman Aug 22 '19 at 9:57

Not the answer you're looking for? Browse other questions tagged or ask your own question.