Whether you build it in a spreadsheet or use a dedicated app, a volunteer log does one job: capture each session completely enough that you can prove it later. Get the fields right and everything downstream - verification, applications, graduation forms - becomes a copy-and-paste job instead of a research project.
The columns every log needs
These are the fields that requirement forms and applications ask for. Include all of them:
- Date - the specific day of the session.
- Organization - the full official name.
- Start time - when you began.
- End time - when you finished.
- Break (minutes) - any unpaid break time to subtract.
- Total hours - the calculated result for the session.
- Activity description - one specific line about what you did.
- Supervisor - name and role of who oversaw you.
- Contact - the supervisor's email or phone for verification.
- Verified? - a simple yes/no or a note on where the proof lives.
Why start and end times, not just a total? Recording the actual window (and breaks) lets you defend the number. "9:00-13:30, 30-min break, 4 hours" is far more credible than a bare "4" - and it prevents the rounding drift that makes totals look inflated.
The template
Here is the log itself. Copy it straight into Excel, Google Sheets or Numbers, or download it as a CSV file. It arrives with the header row, two filled example rows so you can see the level of detail that holds up, and blank rows to start on. You can leave the examples out with the checkbox underneath.
Volunteer hours log template
Free to use, nothing to sign up for. The two filled rows are Volunteerly examples.
| Date | Organization | Start | End | Break (min) | Total hours | Activity description | Supervisor | Contact | Confirmed |
|---|---|---|---|---|---|---|---|---|---|
| 2026-10-18 | Parkdale Community Food Bank | 9:00 | 12:30 | 20 | 3.17 | Sorted donations by category and expiry, packed 34 weekend hampers | R. Mensah, Volunteer Coordinator | volunteers@example.org | Yes, email Oct 19 |
| 2026-10-25 | Riverside Public Library | 13:00 | 16:00 | 0 | 3.00 | Ran the Saturday homework help table for grades 4 to 6 | T. Okafor, Branch Programs | 555-0142 | Not yet |
Above the table, keep a small summary block with your name, your goal (40 hours for the Ontario requirement, or whatever your school asks for) and a running total.
The two formulas worth adding
Do not calculate the total by hand for every row. Assuming your header is row 1, so the first entry lands in row 2, and the columns are laid out as they are above:
- Total hours for a session, in
F2:=ROUND((D2-C2)*24-(E2/60), 2)
Drag it down the column. This subtracts the start time from the end time, converts the result into hours, then takes off the break minutes. - Your running total, anywhere in the summary block:
=SUM(F2:F500)
For those to work, the Start and End columns need to be formatted as times rather than plain text. If your totals come out as something unexpected like 0.13, that formatting is almost always the reason.
How to total hours correctly
If you're calculating by hand, work in minutes to avoid errors:
- Convert start and end to minutes past midnight (9:00 → 540, 13:30 → 810).
- Subtract start from end (810 - 540 = 270).
- Subtract break minutes (270 - 30 = 240).
- Divide by 60 for hours (240 ÷ 60 = 4 hours).
This is exactly the calculation Volunteerly's Add Hours tool runs for you - enter a start time, end time, and any breaks, and it computes the total instantly, so a mistyped subtraction never costs you credit.
Spreadsheet vs. a dedicated tracker
Both work. Choose based on how much upkeep you want to own:
A spreadsheet is great when…
- You want a free, fully manual option and you'll keep it updated.
- You're comfortable maintaining formulas and totals yourself.
- You only need a plain record with no export formatting.
A dedicated tracker is better when…
- You want totals, breaks, and goals calculated automatically.
- You need a polished PDF to submit to a school or scholarship.
- You'd rather not risk losing a file or forgetting to update formulas.
Whichever you choose, log promptly
The template only works if it's current. Fill in each session the day it happens, keep any confirmation emails with the entry, and check your total against your goal regularly. For the full habit around it, read how to track your volunteer hours, and when it's time to make hours official, see how to prove them.
Prefer not to maintain a sheet at all? Volunteerly gives you every field above, does the math and totals automatically, and exports a submission-ready PDF whenever you need one.