Please refer to the attached file. I'm trying to concoct a formula that considers the fee table above, while considering the times associated with the fee schedule, and then considers the in/out times and applies the appropriate total to the charge column. Also, the formula would need to consider the accumulated hours over 40 at 1.5 times the appropriate rate based off of the in/out times.
It's as confusing to explain as it is to try and create. I just registered, but I refer to this site regularly....genius aplenty here. Looking forward to your thoughts. Thank you! Dazed & Confused
Bookmarks