Forum Discussion
How to stop excel from rounding when multiplying by 48
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.
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.
- Oh my goodness, I can't believe I didn't realize that. Thank you so much; I have been working on this for weeks trying to figure it out what I was doing wrong.
