|
|
| Re: Excel (1457622) | |||
 |
|||
| Home > SubChat | |||
|
[ Read Responses | Post a New Response | Return to the Index ] |
|
||
|
Re: Excel |
|
|
Posted by Bill West on Sun Dec 10 02:32:05 2017, in response to Re: Excel, posted by BusRider on Sat Dec 9 13:41:47 2017. You are most welcome.For the rounding, it could be applied to the finish time, the ST calc, the OT calc or the payroll calcs. What it shouldn't be is applied multiple times. If it is applied to ST then in my layout OT will be rounded in the opposite direction. So if the rule is to round up, then CEILING is what we should work with and the problem must be in the layout of my solution. I found an old MTA union contract as a sample to read, this field is complicated. It must be fun for the Agency IT departments to program new contracts when they come out. The clauses are reasonable but making a logical chart to account for all the situations where they apply and sorting out the conflicts between them would be a challenge. Not appreciating all the details is why I imposed an 8 hour minimum day at F15 when in fact there's more to it. So for now I think we've roughed out some concepts for Excel and I'll let you push on with fitting it to the details in the contract you are looking at. If after you have all the rules in place Excel still gives you trouble I'd be happy to jump in again. Bill |
|
|
|