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