The Apple Support Community will permanently close on November 20, 2026. Starting today, the site will no longer accept new posts and is available in a read-only state.
You can continue to find trusted guidance and support on the official Apple Support site.
We want to thank the community members who have contributed their time and expertise to help others with their Apple products.
The Apple Support Community will permanently close on November 20, 2026. Starting today, the site will no longer accept new posts and is available in a read-only state.
You can continue to find trusted guidance and support on the official Apple Support site.
We want to thank the community members who have contributed their time and expertise to help others with their Apple products.
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)
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.
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.
What are you expecting it to come out to? 50h 4m = 50.0666... hours. Multiply that by 450 and you get 22,530.
Pay calculation of hours x dollars gives wrong amount!?
