Forum Discussion
aramark_176
May 24, 2019Copper Contributor
Excel formula Help!!!
I need to create a formula calculating sick time. It's total number of hours worked/30 plus previous balance, but I only want the sheet to show a maximum of 40 hours. I eneter the hours worked each ...
Twifoo
May 24, 2019Silver Contributor
Wrap your formula with MIN like this:
=MIN(SUM(A1:C1)/30+D1,40)
=MIN(SUM(A1:C1)/30+D1,40)