I am creating a timesheet template and have it all figured out except this
one column. Here is what I would like to do:
If column AE4(Actual hours worked) is greater than 168 than add one until
171 is reached. Or if column AE4(Actual hours worked) is less than 168 but
cloumn
AJ4(Total time) is greater than 168 than AJ4-168.

This is hard to come up with a function that fits. Here is the case in
simple terms. The first three hours over 168 go to comp time than anything
exceeding 171 hours go to overtime. Also, if actual hours worked is less
then 168 but total time exceeds 168 than anything over 168 goes to comp time.
It hurts my head to even write this let alone understand it. Thanks for anyt