Attached is a simple example - you can expand it.
On sheets Volunteers and Clients in column A full names are calculated. To prevent formulas accidentally been overwritten, the columns with full names are hidden;
As there is always a possibility you'll have to cope with 2 (or more) people having same name, there is possibility to add something what makes such names different (when there is something entered into field Ext, then this is added at end of full name);
Total Time and column Hrs on ActivityRegistry sheet are formatted to display more than 24 hours;
Total Time on sheet ActivityRegistry displays total of filtered records. I.e. when you set in table the autofilter e.g. to some activity, client, volunteer, or date range, or to any combination of them, only Hrs for visible records are summarized.
|