# 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.

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)

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

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

Or try:

In B1: =MIN(7.6,A1)

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

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1