I am trying to create a formula in Numbers which takes a duration and calculates what percentage this is of another duration.

For example, I have a duration of 1h 30m in cell A1. I want to calculate what this is as a percentage of 9h. I am trying to output 17%.

I tried diving the cell A1 by 9, but this (rightfully) outputs a duration as A1 is being divided by a number. I need to divide A1 by another duration (i.e. 9h) in order to get a fraction. Is it possible to do this directly in the formula? The only other way I can how to do it is by inputing a duration of 9h into cell B2, and then writing =A1/B2. However, I would prefer being able to avoid using the auxiliary cell B2 when performing this calculation.

  • great question pretty sure this also works in excel – JBis Jul 30 '18 at 4:44
  • 2
    @JBis thanks! It definitely should. Also probably with addition, subtraction, maybe even modular arithmetic! – Skeleton Bow Jul 30 '18 at 16:55
  • 2
    Glad I could help! I learned something too. Didn't know Excel/Numbers could use math with durations. – JBis Jul 30 '18 at 16:56

Divide by text in quotes.

So if you want to divide A1 which contain "1h 30m" by "9m" then use the following function A1 ÷ "9m" (A1 contains "1h 30m"). This is the equivalent of putting "9m" in B1 and then in using the function "A1 ÷ B1" in C3: Both will give you 10 because 9 minutes goes into 1 hour 3 min 10 times.

enter image description here

You must log in to answer this question.

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