Pay calculation of hours x dollars gives wrong amount!?

SS says 50.067 hours times $450 = $22,530.00 <-- WRONG

The calculator says 50.067 x 450 = 22530.15

Is the issue that the cell with 50.067 (dur2hours 50h 4m) may have a hidden value of 50.066666-> ???

IF so, how can I force the cell value of 50.06666-> to match the rounded display value of 50.067?

Or is this not the issue I am having?

MacBook Pro (M2, 2022)

Posted on Mar 21, 2024 3:10 PM

Top-ranking reply

Badunit

Level 7

31,321 points

Posted on Mar 21, 2024 5:39 PM

ROUND(your_dur2hours_formula,3) will round it to 3 decimals but then it won't be the same as 50h 4m. Which one of those two is the official number of hours to use in the calculation? The difference of 15 cents doesn't seem big but it would be to an accountant and perhaps might irritate the recipient if it happened to round down instead.

View in context

Similar questions

Numbers calculating incorrect?! Hello all. I am attempting to use Numbers to fill out and file sales taxes on behalf of our business. I have used Numbers before as basically just a template to hold numbers that I done the calculations by hand, but decided I would give a try at using formulas within numbers to do the calculations for me. The riff? The calculations are coming back incorrectly and I am scratching my head! We’re talking about literal pennies here.. but we all know Uncle Sam doesn’t play about pennies. If I can’t get these formulas to work, I’ll just end up going back to doing the calculations by hand and plugging in the final figures into Numbers as a reference, but I’m just trying to simplify my life. I’ve attached two screenshots of incorrect calculations, can someone PLEASE point me in the right direction? I am NOT using any rounding formulas, I am only using Sum(cell+cell); Sum(cell x cell); so on, so forth. As you can see in the first image, Numbers is trying to tell me that 54.81 - 0.82 = 53.98; but that is incorrect. It should be 53.99. Again, as seen here: 2,824.65 - (.944% Comp = 26.66) = 2,797.98 This is again false, it should be 2,797.99 This would possibly be acceptable for entities that want you to round your figures, but unacceptable for entities that want the exact number, which is most of them. Please help?
1382 7

2 replies

Top-ranking reply

Badunit

Level 7

31,321 points

Mar 21, 2024 5:39 PM in response to kenbutcher

Badunit

Level 7

31,321 points

Mar 21, 2024 3:57 PM in response to kenbutcher

What are you expecting it to come out to? 50h 4m = 50.0666... hours. Multiply that by 450 and you get 22,530.

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Pay calculation of hours x dollars gives wrong amount!?