![]() |
|
#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 Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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 |
Tracking Amounts
|
teza2k06 | Excel | 1 | 04-13-2014 09:28 PM |
Vlookup help for large amounts of stock data
|
jyfuller | Excel | 15 | 09-21-2012 11:35 AM |
indent alternate lines by different amounts
|
rufusfrog | Word VBA | 5 | 02-25-2012 03:36 AM |