Forum Discussion
Solved
How to stop excel from rounding when multiplying by 48
I am ultimately trying to determine the hourly cost. I converted HH:MM to decimal (hh:mm*24) then multiplied that by the $48 per hour. The issue is when I multiply by 48, the final product is rounded to a whole number. I would like the round to the nearest cent. I have tried multiple formulas =Round(cell,2), and changing the cell formatting, copying and pasting the product of the conversion as a number, but anytime I multiply by 48 (any other number except 48 works), the number is rounded to the nearest whole number. Please help.
Hi,
To increase the limit Open DataModel connection properties and within it increase the limit
However, if you have an empty list on drill down I don't think that's due to first 1000 rows limit.
4 Replies
It depends on the times. If they are a multiple of 5 minutes, the result will indeed be a whole number, but not otherwise.
HansVogelaar Thank you for your response. Why would 5mins matter? For instance 20 minutes = .33; why is it 16.00 and not 15.84? What formulas did you use? This is what I am getting.
Because 20 minutes is not exactly 0.33. It is 20/60 = 1/3 of an hour (0.3333333... decimal).
1/3 * $48 = $16.
All your times are whole multiples of 0:05. 5 minutes = 5/60 hour = 1/12 hour.
1/12 * $48 = $4, so all the amounts are whole multiples of $4.
