Assuming worked hours are always indicated by a number such as 1 (as you
show), you should be able to get the totals that you show on the right with a
formula like

=COUNT(B2:BA2)/4

but that gives me .75 for Employee 1, not 0.5

As for the times on break or lunch, assuming they are entered with letters
instead of a numbers,

=(COUNTA(B2:BA2)-COUNT(B2:BA2))/4


On Wed, 17 Nov 2004 09:15:04 -0800, "Sicarii"
wrote:

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