---
name: time-audit-sheet-optimizer
description: "Designs a time-audit spreadsheet in uniform slots with category tagging and a summary that flags over-allocated categories for busy professionals. Use when you want a time-audit spreadsheet with uniform slots, category dropdowns, and a summary that flags where you over-spend time. Do not use for a printable hand-filled sheet or analysing a log you have already filled. Related topics: productivity, work, time."
---

# Time Audit Sheet Optimizer

Designs a time-audit spreadsheet in uniform slots with category tagging and a summary that flags over-allocated categories for busy professionals.

## When to use

Use this skill when you want a time-audit spreadsheet with uniform slots, category dropdowns, and a summary that flags where you over-spend time. Do not use it for a printable hand-filled sheet or analysing a log you have already filled.

## 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. Split the working day into uniform slots of the chosen length and list the column headers.
3. Restrict the category column to the chosen list, adding Break when requested.
4. Build a summary table of minutes and share of time per category for the period.
5. Propose and justify an over-allocation threshold per category and describe the highlight rule.
6. Provide the formulas or instructions suited to the chosen output type.

## Inputs

- **Audit period** (free text, e.g. "2026-09-01 to 2026-09-07")
- **Primary work categories** (choose any: Meetings, Coding, Design, Emails, Research)
- **Time slot length in minutes** (number from 10 to 120)
- **Include breaks** (choose one: Yes, No)
- **Output type** (choose one: Excel, Google Sheets, CSV)

## Output

A spreadsheet layout in the chosen format with the log columns, a per-category summary table, the highlight rule, and the formulas.

## Prompt template

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

### Time Audit Sheet Optimizer

Design a time-audit spreadsheet that shows me which categories take too much of my time.

- Audit period: {{Audit period}}
- Primary work categories: {{Primary work categories}}
- Time slot length in minutes: {{Time slot length in minutes}}
- Include breaks: {{Include breaks}}
- Output type: {{Output type}}

Divide the working day into uniform slots of the chosen length. Lay out columns Date, Time Slot Start, Time Slot End, Category, Description, Notes, with the category column restricted to my list (plus Break if requested) so entries stay consistent. Below the log, add a summary table that totals minutes per category over the whole period and shows each as a share of logged time. Add an over-allocation rule: highlight any category above a threshold you propose and justify, for example Emails above 20 percent. Give the formulas needed for the chosen tool, such as SUMIF for the totals, or plain instructions if CSV.

## Pitfalls

- Using slot lengths that do not divide the day evenly, which leaves a stray partial row.
- Leaving the category column as free text, so the same category appears under three spellings.
- Setting one flat threshold for all categories, when meetings and deep work warrant different limits.
