# Max value in one cell - Time sheets

1. ## Max value in one cell - Time sheets

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.  Register To Reply

2. ## Re: Max value in one cell - Time sheets

You will need two formulae:

In B1: =MIN(7.6,A1)

In C1: =IF(B1<=7.6,"",A1-B1)  Register To Reply

3. ## Re: Max value in one cell - Time sheets

Hi xcentriq,

I think you are looking for the Median() formula. See the attached with an example: ``Please Login or Register  to view this content.``
Median for Work Overtime.xlsx  Register To Reply

4. ## Re: Max value in one cell - Time sheets

Or try:

In B1: =MIN(7.6,A1)

In C1: =IF(A1=B1,"",A1-B1)  Register To Reply