Trying to make an sheet to calculate my work hours and I need to limit the number of hours worked in one cell, and anything over the limit should be put into another cell for overtime work.
example:
8 hours shift worked - Cell A
7.6 MAX hours normal pay - Cell B
0.4 hours overtime pay - Cell C
Is there one formula that I can put in Cell B that automatically limits hours to 7.6 and if Cell A is a value above that limit, the rest will automatically go into Cell C?
If one formula for CELL B won't work then, I could use two separate formulas for both cells.
Bookmarks