---
name: time-audit-sheet-helper
description: "Generates a ready-to-print time audit grid with time slots, task categories, and notes so a freelancer can log a day by hand and see where hours go. Use when you want a printable time tracking sheet to log what you do all day by hand and find where your hours go. Do not use for analysing hours you already logged or building a spreadsheet with formulas. Related topics: productivity, work, time."
---

# Time Audit Sheet Helper

Generates a ready-to-print time audit grid with time slots, task categories, and notes so a freelancer can log a day by hand and see where hours go.

## When to use

Use this skill when you want a printable time tracking sheet to log what you do all day by hand and find where your hours go. Do not use it for analysing hours you already logged or building a spreadsheet with formulas.

## Workflow

1. Ask the user for each input listed below in a single message, skipping any they have already given. Where options are listed, offer them, but accept other answers too.
2. Title the sheet with the date range and set the slot rows from the time interval.
3. Create category columns from the selected categories, plus a notes column and a lunch column if asked.
4. Fit the column count to the chosen orientation, trimming spacing rather than categories.
5. Repeat the blank table once per day for the requested number of days.
6. Add a short instruction paragraph covering how to log entries and total them.

## Inputs

- **Date range** (free text, e.g. "2026-10-01 to 2026-10-07")
- **Time interval** (choose one: 15 minutes, 30 minutes, 1 hour)
- **Work categories** (choose any: Project work, Meetings, Administrative, Learning, Breaks, Other)
- **Include a lunch break column** (choose one: Yes, No)
- **Sheet orientation** (choose one: Portrait, Landscape)
- **Number of days** (number from 1 to 14)

## Output

A plain markdown document with a dated title, one empty table per day with time slots and category columns, and a closing instruction paragraph.

## Prompt template

Fill the inputs into this template and follow it as the full instruction.

### Time Audit Sheet Helper

Create a blank, printable time audit sheet I can fill in by hand.

- Date range: {{Date range}}
- Time interval: {{Time interval}}
- Work categories: {{Work categories}}
- Include a lunch break column: {{Include a lunch break column}}
- Sheet orientation: {{Sheet orientation}}
- Number of days: {{Number of days}}

Title the sheet with the date range. Build a markdown table with one row per time slot at the chosen interval across a working day, and columns for time, one tick column per selected category, a notes column, and a lunch column if requested. Keep the column count to what fits the chosen orientation: Portrait suits the hour interval with few categories, Landscape suits shorter intervals. Repeat the table once per day for the number of days. Leave every response cell empty. Put a short instruction paragraph at the bottom explaining how to log (tick one category per slot, note interruptions) and how to total the sheet at the end of the period.

## Pitfalls

- Choosing a 15 minute interval with six categories in portrait, which makes columns too narrow to write in.
- Pre-filling cells, which defeats the purpose of a blank sheet.
- Allowing multiple categories per slot, which makes totals ambiguous.
