Calculation Field Question
I'd like to create a calculation field that will give me a total of hours when a work week goes over 37.5 hours total, but if the weekly total goes over 40, will give me a max total of 2.5 hours. I've already got the calculation for when the hours go over 40. I've tried embedded If statements, as well as Case statements, but I'm just not getting it right.
Thanks in advance for any advice you can give me.