Hello,
I'm trying to figure out if it is possible with Excel to do this or if
maybe Access would be better. I have employee names in column C and times in
row 2. The times go from 8:00am - 9:00pm in 15 minute intervals. There is a
1 in each cell that the employees work.
What I would like to do is set it up so that Breaks and lunches are
automatically set based on some criteria. It would need to either add up the
hours worked in the day or look at the total hours worked (the sum of 1's).
It also needs to check the percentage offline.

This is a very generic representation, but I don't know how to attach a
snippet of the code.
8:00 8:15 8:30 8:45 9:00
Employee 1 1 1 1 .5 hour
Employee 2 1 1 B 1 1 1 hour

%offline 0 0 50% 0 0

--
If you fail to plan, then you plan to fail.