Free Excel template

Free volunteer hours log template

Q: How do I total hours between two dates?

Use SUMIFS with two date conditions, for example =SUMIFS(D8:D27,A8:A27,">="&B4,A8:A27,"<="&B5), or add a helper column that says Yes for dates in the period, as this template does, and sum the Yes rows.

Q: Can students use this for service-hour requirements?

Yes. Set the goal in B2 to the hours your school requires, leave the report period wide enough to cover the whole requirement, and have a supervisor initial each shift on the printed log if your school asks for proof.

For volunteer coordinators, school service-hour programs, clubs and churches that need to know who gave how much time, and when. Log each shift on one row; the template totals hours per volunteer and per program, flags who has met the hours goal, limits a report to the dates you choose, and puts a value on the time using a rate you enter.

cellwise-volunteer-hours-log-template.xlsxExcel workbook · 5.2 KB · works in Excel, Google Sheets, Numbers and LibreOffice · no signup

Download free template

Preview and try it

This is the template's sheet, calculated by the same engine as the Cellwise app. Change any number to see the formulas react before you download.

	A	B	C	D	E	G	H	I
1	Volunteer hours log
2	Hours goal per volunteer	20
3	Value per volunteer hour	30
4	Report period from	Sep 1, 2026
5	Report period to	Oct 31, 2026
6
7	Date	Volunteer	Program	Hours	In period?	Program	Hours in period	Share
8	Aug 22, 2026	Maria Lopez	Food pantry	4	No	Food pantry	20	0.34482758621
9	Aug 29, 2026	Sam Okafor	Park cleanup	3	No	Tutoring	11.5	0.19827586207
10	Sep 5, 2026	Maria Lopez	Food pantry	4	Yes	Park cleanup	9.5	0.16379310345
11	Sep 6, 2026	Priya Shah	Tutoring	2	Yes	Fundraiser gala	17	0.29310344828
12	Sep 12, 2026	Tom Becker	Park cleanup	3.5	Yes	Total	58	1
13	Sep 13, 2026	Priya Shah	Tutoring	2	Yes
14	Sep 19, 2026	Grace Kim	Food pantry	4	Yes
15	Sep 20, 2026	Sam Okafor	Tutoring	1.5	Yes
16	Sep 26, 2026	Maria Lopez	Fundraiser gala	6	Yes
17	Sep 26, 2026	Grace Kim	Fundraiser gala	6	Yes
18	Sep 26, 2026	Leo Martin	Fundraiser gala	5	Yes
19	Oct 3, 2026	Priya Shah	Tutoring	2	Yes
20	Oct 4, 2026	Tom Becker	Food pantry	4	Yes

How the formulas work

Total hours per volunteer with SUMIF

B30=SUMIF($B$8:$B$27,A30,$D$8:$D$27)

SUMIF adds the Hours column only on log rows where the volunteer name matches A30. The ranges are locked with dollar signs so you can copy the formula down the summary list. The name must be spelled exactly the same way in the log and the summary: "Maria Lopez " with a trailing space is a different name to Excel, which is why row 39 shows any hours that did not match a summary name.

Mark which shifts fall in the report period

E8=IF(A8="","",IF(AND(A8>=$B$4,A8<=$B$5),"Yes","No"))

Dates are numbers in Excel, so a date can be compared with the start and end of the period directly. AND requires both tests to be true. Change B4 and B5 to report on a term, a quarter or a school year; the In period column and every total that uses it update. In the sample, the August shifts and the November 1 shift fall outside September to October.

Hours in the period, per person and per program

C30=SUMIFS($D$8:$D$27,$B$8:$B$27,A30,$E$8:$E$27,"Yes")

SUMIFS adds hours that meet every condition at once: this volunteer, and inside the period. The program table on the right uses the same pattern with the Program column. A grant report or board update usually wants the period figure; the All hours column is for long-running goals like a graduation service requirement.

Who has met the hours goal

E30=IF(B30>=$B$2,"Goal met",IF(B30>=$B$2*0.75,"Almost there","Needs hours"))

The nested IF checks the highest band first. With a 20-hour goal, 20 or more is Goal met, 15 to 19.9 is Almost there, and anything below is Needs hours. Change B2 to your own requirement, or change 0.75 to move the Almost there line. Row 38 counts the volunteers who are done.

A dollar value for volunteer time

F30=ROUND(B30*$B$3,2)

Hours times the value per hour in B3, rounded to cents. Many organizations report this figure to boards and funders. Use the hourly value your organization or funder asks for (some publish a recommended rate each year); the 30 in the sample is only a placeholder. Whether volunteer time can count as in-kind support depends on the funder, so check before you put it in a budget.

Make it yours

Keep one row per shift rather than one row per person. It takes longer to type, but you can then report any date range, program or person without rebuilding anything.
Make names consistent with a drop-down: select B8:B27, then Data > Data Validation > List, and point it at A30:A35. A new volunteer is added to the summary first, then appears in the list.
Need more log rows? Insert rows inside the log (above row 27) so the SUMIF and SUMIFS ranges stretch to include them. Rows added below the last log row are not counted.
Highlight people who still need hours: select E30:E35, then Home > Conditional Formatting > Highlight Cells Rules > Text that Contains, type Needs and pick a fill color.

FAQ

How do I track volunteer hours in Excel?

Log every shift on its own row with the date, the volunteer, the program and the hours. Then total each person with =SUMIF(names,person,hours), and add a date condition with SUMIFS when you need hours for a specific period.

How do I total hours between two dates?

Use SUMIFS with two date conditions, for example =SUMIFS(D8:D27,A8:A27,">="&B4,A8:A27,"<="&B5), or add a helper column that says Yes for dates in the period, as this template does, and sum the Yes rows.

Can students use this for service-hour requirements?

Yes. Set the goal in B2 to the hours your school requires, leave the report period wide enough to cover the whole requirement, and have a supervisor initial each shift on the printed log if your school asks for proof.

Functions used

Related guides

More free templates

Updated November 2, 2026