Validate a total of a row
 

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

Validate a total of a row
 

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


"Charles" wrote:

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