Marriner330

Dec 25, 2012, 07:37 PM

Hello,

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,

marriner330

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,

marriner330