maximum amount of hours

bam12

Well-known Member
Joined
Dec 6, 2004
Messages
983
I need to set a maximum amount of hours a person may accumulate

so on i6 i have the formula sum(i4:16), but this I6 cant go over 720 hours and maybe have pop up come up when this reached

thanks in advance for any help
 

Some videos you may like

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

Scott Huish

MrExcel MVP
Joined
Mar 17, 2004
Messages
19,958
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
This will limit the result to a max of 720:

=MIN(SUM(I4:I16),720)

Then why not use Conditional Formatting to color the cell with a formula something like this:

=SUM(I$4:I$16)>720
 

Watch MrExcel Video

Forum statistics

Threads
1,114,095
Messages
5,545,923
Members
410,713
Latest member
TaremyLunsil
Top