=SUM($A$1:$A$5)<=--"40:00"
I assume you apply it in the cell where the end time is entered
of course if you are not using time values use <=40 instead
--
Regards,
Peo Sjoblom
http://nwexcelsolutions.com
"brodiemac" wrote in message
...
I have a spreadsheet that our different locations used for scheduling. For
each day of the week, the manager selects a start time and an end time.
The
total hours then calculates in the last column using a SUM formula. What
has
been requested is that an error pop up when that SUM forumula calculates
hours that are greater than 40. I've tried every variation in data
validation that I can think of but I can't get anything to work. Any
suggestions welcome. I am working in Excel 2002. Thanks!