How It Works
- Open the Daily Log tab. Every row is one hour of the day (12:00 AM to 11:00 PM), and every column is a day of the week, Monday through Sunday.
- Click any cell in the grid and choose a category from the drop-down — Sleep, Work/Job, Study/Homework, and so on. Do this for every hour you're awake and active; it takes a couple of minutes a day if you fill it in as you go.
- Each category is color-coded automatically, so after a few days you'll see your week — long blocks of one color mean that activity is dominating your time.
- The Weekly Summary tab totals your hours per category, per day, automatically. No data entry needed there.
- The Dashboard tab turns those totals into a pie chart and a bar chart, so you can spot at a glance what's taking the bulk of your 24 hours.
Category Color Key
Sleep
School / Class
Study / Homework
Work / Job
Commute
Meals / Self-Care
Family / Household
Exercise / Health
Screen / Leisure
Other
Inside the Workbook
Daily Log
Your only input tab. A 24×7 grid with a drop-down in every cell and conditional-format color rules already wired to the category list — edit column B onward, rows 2–25.
Weekly Summary
Totals hours per category per day with formulas — nothing to fill in. A running total confirms each day adds back up to 24 hours.
Dashboard
A pie chart of your week by category and a bar chart of hours by category and day, both pulling live from Weekly Summary.
Download the Tracker
Free .xlsx workbook — Start Here guide, Daily Log grid, Weekly Summary, and Dashboard, ready to fill in.
Compatibility note: Built as a standard .xlsx workbook — opens in Excel (2010 or later), Google Sheets, LibreOffice Calc, and Numbers. Category drop-downs and color-coding are driven by native data validation and conditional formatting, not macros, so no "enable content" prompt is required.