Lesson Hearth / Free guides

Homeschool hours log: a free printable and how to track learning hours

Some home-educating parents keep a log of learning hours as well as school days. It shows how time is split between subjects, helps with planning, and gives you a clear record if your local rules ask for one.

Requirements differ a lot between states and countries. Some ask for a number of hours, some for days, some for neither. Check what your local rules ask you to record. This log is a record-keeping aid for parents, not legal advice.

Decide what counts before you start

The hardest part of an hours log is not the adding up. It is deciding what to write down. Make these decisions once, write them at the top of your log, and apply them all year.

• Formal lessons: math, reading, writing and other subjects at the table. These almost always count.
• Independent work: reading a set book, practicing an instrument, online courses.
• Hands-on learning: baking with measuring, gardening, building projects. Decide which subject each one counts toward.
• Trips and outings: museums, nature walks, historic sites. Count the time spent learning, not the drive.
• Co-op classes and lessons: sports, music lessons, group classes.
• Reading aloud: family read-alouds count toward literature or the subject of the book.

If your local rules define what counts, follow them. If they do not, a sensible, consistent rule you can explain is the goal.

Minutes or hours?

Log minutes, not hours. "35 minutes of math" is easier to write in the moment than "0.58 hours", and a spreadsheet can convert it for you. Round to the nearest five minutes. Nobody needs a stopwatch.

An example day

Here is how one ordinary Tuesday might look in the log for a ten-year-old. Nothing fancy, just enough to show what happened:

• Math: 40 minutes, lesson 52 and practice page
• Reading: 30 minutes, independent reading of a chapter book
• Writing: 25 minutes, first draft of a letter to a grandparent
• History: 35 minutes, read-aloud and map work with siblings
• Science: 45 minutes, plant experiment in the garden
• Music: 20 minutes, piano practice

That is 195 minutes, or 3.25 hours, written down in about two minutes at the end of the morning.

Paper or spreadsheet?

Both work. Paper is quick to fill in and easy to keep by the table, and many parents like a physical record they can file. A spreadsheet does the adding up, shows monthly and yearly totals, and handles several children without extra sheets. Some families use both: paper during the week, then five minutes on Friday copying totals into the spreadsheet. Pick the one you will actually keep up.

Totaling hours in a spreadsheet

A spreadsheet saves you adding columns by hand. The simplest setup is one row per learning session, with these columns: A date, B child, C subject, D minutes, E notes.

• Hours for one child in one subject: =SUMIFS(D:D,B:B,"Child name",C:C,"Math")/60
• Total hours for one child: =SUMIF(B:B,"Child name",D:D)/60
• Hours in one month: =SUMIFS(D:D,B:B,"Child name",A:A,">="&DATE(2026,10,1),A:A,"<"&DATE(2026,11,1))/60
• Progress toward a target you set: =TotalHours/TargetHours, formatted as a percentage

Make the Child and Subject columns drop-downs (Data, Data validation) so names are spelled the same way every time. Otherwise "Math" and "Mathematics" end up as two subjects.

Fitting it into your day

A log that takes twenty minutes a day will not last until spring. Ways to keep it quick:

1. Log at the same time every day, such as after lunch or at the end of lessons.
2. Keep the sheet where you teach, on a clipboard or on the fridge, with a pen attached.
3. Let older students log their own independent work, and check it at the end of the week.
4. Fill gaps from your planner. If you plan lessons on a weekly page, the plan plus a check mark shows what happened.
5. Total weekly, not daily. Add up each subject on Friday and move the totals to a term summary.

More than one child

When you teach several children at once, a shared lesson counts for each child who took part. If three children did a 40-minute science lesson together, log 40 minutes for each. A spreadsheet with a Child column handles this: add one row per child, or use a "Together" entry and count it for everyone.

At the end of each term

• Total hours by subject for each child
• Compare with any targets you set, and adjust next term's plan
• Note books finished, projects completed and trips taken
• Keep a few work samples with the log
• Back up digital records and file paper ones safely

Tips

• Write down the rule you use for half days, trips and co-op classes, and keep it with the records.
• Do not count the same minutes twice under two subjects.
• Log what happened, not what was planned.
• Keep it in proportion. The record serves your teaching, not the other way around.