42:33:00:N/001:34:59.88:W
If you copy E2 and paste values elsewhere, it gives 0.549999999999997 hence why that value multiplied by 60 doesn't give an exact 33.
Change the formula in E2 to:
=ROUND(C2-D2,2)
use the ROUND function on values in column I and R. Internally,
If you are experiencing a similar issue, please ask a related question
Title | # Comments | Views | Activity |
---|---|---|---|
why excel offset of negative and positive shows incorrect Delta, please see attached | 2 | 17 | |
how to add loop into this VBA | 3 | 29 | |
Excel Charts: How is this Chart made? | 8 | 28 | |
Excel 2010: Creating a "Yes" or "No" Pop-Up | 20 | 42 |
Join the community of 500,000 technology professionals and ask your questions.