68

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

1 Answer 1

97

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

2
  • 3
    Very useful answer. But what a guess..! Jun 11, 2019 at 16:23
  • The guess was super helpful! Thanks! Aug 22, 2019 at 9:57

Not the answer you're looking for? Browse other questions tagged .