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