ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   need cell validation formula help (https://www.excelbanter.com/excel-discussion-misc-queries/54513-need-cell-validation-formula-help.html)

adear11

need cell validation formula help
 
I need some assistance with creating a formula to use in validating cells on
a time card worksheet.

Here is what I need:

For a particular day, the sick,vacation, and personal time entered can not
make the total hours for the day more than 8.

for example, if I work 8 hours today, I can not enter any of the other time.
Or if I only work 4 hours today, I can only have up to 4 hours of other time.

I already have a rule that will not allow the total number of sick, vaction,
and personal time not sum to be more than 8 hours a day.

Can someone help me please?


All times are GMT +1. The time now is 07:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com