Created attachment 95514 [details] Example of payroll spreadsheet showing incorrect calculations Problem description: Doing a payroll spreadsheet in Calc. Times are calculated in 10 minute increments. Employee is paid $10 per hour. If employee works 19.67 hours, the total should be $196.70. Instead, Calc calculates the pay as $196.67. Steps to reproduce: 1. Create a spreadsheet. Set up columns for beginning time and ending time (as time values), and for the total time expressed as a decimal value: (EndTime-StartTime)*24. 2. Set a cell to contain the hourly pay rate, expressed as dollars (in this case, $10) 3. Set a cell to calculate the total hours worked (i.e., "=SUM(E14:E22)") 4. Set a cell to calculate the total pay, referencing the cells described in steps 2 and 3 above. Current behavior: If the total hours worked are 19.67 and the pay rate is $10/hour, the total pay should be calculated as $196.70. Instead, the total pay is calculated as $196.67. Expected behavior: The total pay should be calculated as $196.70 (the correct value). Operating System: Windows 8 Version: 4.1.2.3 release
Hi Steven, Values in total hours have more than 2 decimals, add more decimals to the format in E14:E22 and in B23, so you can see what is happening. Using the ROUND() function can be useful to get what you want. I think there is not a bug. Changed status to Resolved Notabug. If you are not agree, please reopen it.