Forum Discussion
Calculation returns wrong value
- Jun 15, 2021I suspect H33 is not 0.18, but 0.18333333 (11 minutes). Regardless of how you format the cell, it doesn't change the actual value of the cell contents.
Try: =Round(H33,2)*G34
SergeiBaklan wrote: ``Yes, correct answer is 3.78 based on FLSA-2019-9``
I removed my comments about whether or not to round hours to 2 decimal places. My comments were intended to be "food for thought" for the Jenni58 , not about the solution presented by JMB17 .
But given the tone of the follow-up responses, I renew my suggestion to Jenni58 to consult __state__ labor laws regarding rounding, if this is truly an important payroll matter.
First, FLSA-2019-9 applies to __federal__ labor laws. They may or may not apply to Jenni58's situation. For example, a 2018 California Supreme Court decision holds that California labor laws do not "incorporate" certain guidelines found in the FLSA.
Second, FLSA-2019-9 does __not__ dictate that hours should be rounded to 2 decimal places. On the contrary, FLSA-2019-9 states that ``FLSA regulations __allow__ employers to round employees' starting and stopping times to the nearest five minutes, or to the nearest one-tenth or quarter of an hour``.
And even that is not a mandate. Note the word "allow", not "require".
The purpose of FLSA-2019-9 is to address the question of whether one __employer's__ practice of rounding hours to 2 decimal place is compliant. FLSA-2019-9 does conclude that ``this method of rounding __complies__ with the FLSA``.
But the operative word is "complies". Again, it is not "required" or even a "guideline".
Third and more to the point, Jenni58 seems to work for GT Landscape Solutions - King, which might be a company in Oregon or California. So Oregon or California labor laws might apply.
Off-hand, I cannot find Oregon and California regulations regarding rounding hours for the purpose of calculating pay.
But as a demonstration that they might not follow federal DOL guidelines, I note the following excerpts from one lawyer's presentation at a conference on Oregon labor laws, which contrast Oregon and "FLSA/Washington" practices regarding rounding start and stop times (not the rounding of hours per se for the purpose of calculating pay).
-----
OREGON: no authority permitting rounding. Oregon statutes refer to "all wages" paid.
FLSA & WASHINGTON: permit true rounding where the rounding (in practice) works both for and against the employee. Commonly called the "7 minute rule".
Key is whether by calculation or practice the round tends to favor the employer
-----
Noting that in Jenni58's example, rounding hours to 2 decimal places results in lower pay ("favoring the employer"), it might not be unreasonable to ask whether that practice would be allowed in Oregon and California (if those are even the correct state laws to consider in her case).
Be that as it may, the point of my now-deleted comments was for Jenni58 to ask whether she should round the Excel calculation to match her calculator calculation, or she should perform the calculator calculation to match the Excel calculation (with the exact fraction of hours, namely 11/60).
Only Jenni58 can answer that question dispositively for herself, using due diligence if this is truly an important payroll matter.