[jimhelm]

OK....

so the answer I needed was right at the end of that video.

Fred, You have to format the cells first.
skip two rows for label and header.

1. Highlight B3 over to O3 and down as many rows as you have people you want on your list.

2. right click, format cells, custom, and either select or manually enter this: h:mm am/pm (see attached image for this)

3. column A is for the emp name.

4. column b is mon in, c mon out, d tues in and so on out to column O sun out.

5. highlight column P and format like above, but put this in the Type field [h]:mm (the brackets allow your total to exceed 24 hours)

6. this is the formula for the total hours per week:

=SUM((C3-B3)+(E3-D3)+(G3-F3)+(I3-H3)+(K3-J3)+(M3-L3)+(O3-N3))

cut and past that into field P3

do you know how to drag the cross down from P3 to extend the formula to the adjacent cells?