Validate a total of a row

  • Thread starter Thread starter Charles
  • Start date Start date
C

Charles

I have this, simplified, spreadsheet:
Name A, Name B, Name C, etc in columns B1 to M1
In row 2 to row 11 are Work Functions. The staff have to enter a time
against each function but the total for each row can not exceed 15 minutes.
Can someone help with the formula?

Thanks
 
1. use conditional formating to give you a red flag when the total is not 15
min.
2. Or use VBA to achieve the goal
 
Back
Top