Hi j,
Take a look at the Employee Schedule template in the business section of the Template Chooser.
With a few modifications, it should do what you need.
Start by renaming the main table to reflect the new focus—you—then replace the names in row 1 with the Sunday dates of the weeks being recorded. Each column will then report your total house for one week (in row 25). You can use SUM() to total these in a separate cell or on a separate tabel.
One caution:
The values in the pop-up menus, like those in all cells showing either Date or Time values contain both a Date part and a Time part. Where only the Time part has been entered, the Date part is the Date on which the entry was created. For the pop-ups on this table, that was July 15, 2008, so the full value in cell C7 (John's first "In" time) is July 15, 2008 08:00:00. That full value is what's used in the calculation in C9.
If you edit the pop-up menu lists, there are two things to be aware of:
- The "blank" item in the menus enters an empty string into its cell, not a true blank. You, as a user, cannot create an 'empty string' item in a popup menu. The closest you can come is an entry with a single space. If you edit the "blank" item, you will also need to edit the formulas in the hours rows to detect a space ( " " ) rather than an empty string ( "" ).
- If you add or change any 'time' items in the pop-ups, the new (or changed) items will contain 'today's' date as part of the value. To avoid unexpected results from calculations, you'll need to edit ALL or the 'time' items if you choose to edit or add one.
Take a look at the template, then bring back any questions that arise.
Regards,
Barry
