I'm not sure what you are asking for, because you've already
identified the layout you want. I would suggest five columns per day,
so that you can work out the hours on a daily basis, so with names in
column A this means that you would use B for start-time, C for finish-
time (if they take a lunch break), D for start-time after lunch, E for
finish-time at end of day, and F for hours worked that day. If you
enter times into columns B to E in Excel time format (e.g. 8:00), then
in F3 you could have this formula to evaluate daily hours:
=(E3-D3+C3-B3)*24
Format the cell as a number with 2dp to give you decimal hours. Copy
this down for your 6 members of staff, whose names should be put in A3
to A8.
If a person does not take a lunchbreak then you can leave C and D
blank. I assume you will put headings in row 2, and in row 1 you want
the days - enter "Saturday" in B1, then highlight B1:F1 and click on
Format | Cells | Alignment tab and for Horizontal alignment click on
Centre across Selection.
Then you can highlight columns B to F, click <copy> then click on cell
G1 and <paste>, and then repeat for the other days by moving the
cursor 5 columns to the right and pasting again. You can then edit the
day names in G1, L1 etc.
Your total weekly hours can be put in AF3, and will be the following
formula:
=F3+K3+P3+U3+Z3+AE3
then copy this down.
Hope this helps.
Pete
