How do you limit the total allowed for a group of cells?

A

abby

I am trying to limit the number of hours that my employees can log. How do I
prevent the total of 3 cells from exceeding 80 hours. I tried to limit it
through the validation menu, but I have been unable to figure it out. (By the
way, they can log in decimals, not just whole numbers).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

totaling time in 2 cells w/ total of hours worked in 3rd 2
Finding the proper style field and the numbered paragraph value within the style 0
How to filter rows data based on background color of individual cells 3
Cell Formats - Limit # of characters 5
How to do a formula counting the number of hours between 2 times? 2
Calculating total amount in a Pivot Table 1
How do you put Days and Hours into total hours 11
Urgent help needed? How do I limit the number of characters in a 5

Top