How to use it
- Open the Setup tab. Set the hours goal and the start and end dates of your two terms in the yellow cells.
- On the Hours log tab, add one row each time someone volunteers: date, event, name, email, time in and time out. Type times like 9:00 AM.
- On the Totals tab, type each person's name once, spelled the same way as on the log.
- Check the Totals tab before a deadline. It shows total hours, hours this term, progress like "8.5 / 20" and how many hours are left.
The printable PDF is for one person. A student writes a line per visit, gets the supervisor's initials before leaving and adds up the running total at the end of each line.
What's in it
- Setup: the hours goal and two term date ranges. Change them once and everything else follows.
- Hours log: Date, Event or organization, Volunteer name, Email, Time in, Time out, Hours, Running total (this person), What they did, Supervisor initials. 300 rows.
- Totals: Entries, Total hours, Term 1 hours, Term 2 hours, Goal, Progress, Hours left and Goal met for each person, plus a check that catches hours logged under a misspelled name.
- Example log and Example totals: twelve filled rows with a forgotten checkout, an event that ran past midnight and a row with hours but no times, so you can see how each case behaves.
- Printable PDF: one filled example page and two blank pages with 22 lines each, plus page totals so a long log carries over.
When this file is all you need
If one officer enters hours after each event and your club has a few dozen members, this sheet does the job. It's free, it works offline, and your advisor can open it without an account.
Doing this in Helptivo
In Helptivo, members scan the event's QR code to check in and out, and their hours are worked out from those times and added to their profile. Members can see their own total in the Hour Tracking Portal on your club's public page, and can request hours for outside service, which an Owner or Admin approves. It's free for up to 150 members. Start a free club, or read more about QR attendance.
Questions people ask
Does the volunteer hours log work in Google Sheets?
Yes. Upload the .xlsx to Google Drive and open it with Google Sheets, or use File > Import in a blank sheet. The formulas only use functions that exist in both Excel and Sheets.
How do I change the hours goal?
Type a new number in the yellow Hours goal cell on the Setup tab. Every person on the Totals tab picks it up. To give one person a different goal, type over their Goal cell.
What if someone forgot to check out?
Leave Time out blank and the Hours cell stays empty, so nothing wrong gets counted. Type the time they left once you know it and the hours fill in.
Can I log hours that have no start and end time?
Yes. Leave both times blank and type the number of hours straight into the Hours cell. It replaces the formula for that row only.
Why is a name missing from the totals?
The Totals tab adds up by exact name. Check the line at the top of the Totals tab: if it shows more than 0, some hours on the log belong to a name that is spelled differently or not listed yet.
