## Forum Discussion

ahay_03

Mar 28, 2022Copper Contributor

# 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...

- Mar 28, 2022
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.

HansVogelaar

MVP

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.

ahay_03

Mar 28, 2022Copper Contributor

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.