How to add values only up to a certain number?

Hello! I’m trying to work on a table that’s going to track the baseline hours (90) and extra hours. There are two separate tables that track clock in and clock out times, as well as the number of hours worked for both employees.

As it is, I’d like the cells B2 and B3 to work on the condition that the maximum amount of hours is 90, shared between both of them. And that, after the counter hits 90, that it should instead start showing the remaining hours in the “extra hours” rows. It doesn’t necessary need to split between both employees like it’s showing, it’s okay to be one single cell tracking both.

Is this possible? Or is there a much simpler way to achieve what I’m trying to do? I’ve been staring at this for a long time, so forgive me if I’m missing something incredibly obvious.


Thank you kindly!



[Edited by Moderator]

Posted on Aug 10, 2025 2:09 PM

Reply
Question marked as Top-ranking reply

Posted on Aug 10, 2025 5:17 PM

You can consider using the MIN function, something like this:




The formula in cell B2 of my example:


=MIN(B1,lane::D$11)


Where lane's total hours are in cell D$11 in the Footer Row of the table "lane".


The formula in cell B3:


=lane::D$11−B2



Use ; instead of , in the formula if your region uses , as the decimal separator.


More on MIN here:


MIN - Apple Support



SG


2 replies
Question marked as Top-ranking reply

Aug 10, 2025 5:17 PM in response to DarthLumiya

You can consider using the MIN function, something like this:




The formula in cell B2 of my example:


=MIN(B1,lane::D$11)


Where lane's total hours are in cell D$11 in the Footer Row of the table "lane".


The formula in cell B3:


=lane::D$11−B2



Use ; instead of , in the formula if your region uses , as the decimal separator.


More on MIN here:


MIN - Apple Support



SG


This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

How to add values only up to a certain number?

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.