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

How do you limit the number of charactors in a cell? 2
totaling time in 2 cells w/ total of hours worked in 3rd 2
Cell Formats - Limit # of characters 3
how do I show the total of difference between two times in decima. 3
How to Configure Worksheet to Maximize Number of rows or Columns 1
Keep total of cells in a cell after deleting source data 8
validation formula's and conditional formatting 1
Calculating total amount in a Pivot Table 1

Top