iPad Numbers help

Discussion in 'iPad Apps' started by Marriner330, Dec 25, 2012.

  1. macrumors newbie

    Dec 23, 2012

    I am having trouble with a time calculations in iNumbers on my iPad 2.

    I need to divide 82:00 hours by the number 31 and get the resultant answer in hours and minutes IOW - if a 31 day month is worth 82:00 hours, how much is each day worth in hours and minutes. Then I take that answer and multiply it by a variable number from 1-31.

    I have a cell formatted in Duration - hours and minutes - of 82:00. I divide that cell by 31 and get the answer 2:39 - formatted hours and minutes or 2:38:43 formatted hours minutes seconds. That is correct. The problem is when I multiply 2:39 by 2. The answer I get is 5:17 in hours and minutes format or
    5:17:25 in hours minutes seconds format.

    2 hours and 39 minutes X 2 = 5 hours and 18 minutes, not 5:17.

    What am I doing wrong?

    Thanks for any help,

Share This Page