![]() |
#9
|
|||
|
|||
![]() Quote:
The primary problem was knowing how to calculate overtime for Ohio. It is much simpler than Calif: just 1.5 time for hours worked over 40. So the formula in I2 should be: =ROUND(H2 + MAX(0,H2-40)*0.5) * 9.25, 2) There were also some formulas that require explicit rounding. But that issue was secondary and not related to the "difference". Interestingly, the example Excel file demonstrates why "Precision As Displayed" should not be set in this case. Work time was calculated for each day of the week and converted to decimal hours. The number of hours needed to be calculated exactly (not rounded), but they are formatted to display only 2 decimal places. Setting PAD would have rounded those values to 2 decimal places. |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
IF formula when some values are text & others $ amounts | LyndaH | Excel | 4 | 03-26-2017 08:31 PM |
Adding addresses and $ amounts to Word docs | littlepeaks | Word VBA | 2 | 01-22-2016 07:57 PM |
![]() |
teza2k06 | Excel | 1 | 04-13-2014 09:28 PM |
![]() |
jyfuller | Excel | 15 | 09-21-2012 11:35 AM |
![]() |
rufusfrog | Word VBA | 5 | 02-25-2012 03:36 AM |