I posted an example of a Spreadsheet with all the Information I’m having an issue with.
If I enter time difference in minutes to my calculations manually I get the correct result.
If I use a Formulas that calculates the minutes, I get the same amount of minutes, but a different result for “Hourly Pay” which is wrong…
Full explanation in the Sheet I posted…
Questions.ods (44.0 KB)
If I enter in cell H3 the formula =17/60 then both calculations match. It is a rounding error.
What helps me in these situations is to click the Function Wizard button to see the actual values and not the formatted values. I almost think there should be a feature to toggle formatting, or don’t format until done, or never format to add or remove decimals, always use a version of round.
Got it !
Thank you
Is there anyway that I can get the formula to just Calculate it with 2 Decimal places like “0.28” which is rounded instead of .283333333333 ?
Or should I just use that formula that way that gives me the result of 0.28333333333 to be more accurate ?
You’re in the world of approximate calculations.
Use the ROUND function (or similar) for rounding.
I looked into the ROUND Function and was working on trying to figure how to put it in the Formula.
I’m no good at Formulas trust me. Basics Suns, Averages DIV 0 errors, referring to other sheets in a cell, but never messed with other unfamiliar formulas.
I Found a Solution last night on the LibreOffice online manual and it works great.
“To calculate with the rounded off numbers instead of the internal exact values
Choose Tools - Options - LibreOffice Calc.
Go to the Calculate page. Mark the Precision as shown field and exit the dialog with OK”.
That give me all the exact “Rounded Numbers”.
I know how to do it now just in case, but the more I thought about it I would rather have the .2833333333 actual result used and not “Round it” to have total accuracy.
Thank you !
I think you are better having the accurate figure.
The Precision as shown can give inaccurate results as your spreadsheet inadvertently shows. Better to use the ROUND function for the calculation you want, =ROUND(HOUR(G13) + MINUTE(G13)/60;2). So basically, I have just enclosed your existing calculation with the ROUND function, the ; is a separator (which might change to a comma in your spreadsheet), the 2 at the end specifies the 2 digits after the decimal point.
I would just use =ROUND( G13*24;2 )
Thank you, I changed it.
This formula you posted is much better and only applies to the Column I need.
=ROUND( G13*24;2 )
Ola @dannyg, sugiro trabalhar com minutos em H3, não precisa arredondar nada.
Salut @dannyg, je te suggère de travailler avec les minutes en H3, pas besoin d’arrondir quoi que ce soit.
Questions_GS.ods (41,5,KB)