Prompt Almanac

Create beginner Works with: Any AI

Google Sheets Weekly Timesheet With Checkboxes and Totals

Structured brief Has example

Build a simple timesheet with validation and totals.

Open in ChatGPTOpen in Claude

The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.

Rate this prompt

Loading ratings…

Design a weekly timesheet in Google Sheets for [TEAM]. Projects or categories: [CATEGORIES]. Rules about breaks and overtime: [RULES]. Overtime threshold in hours: [THRESHOLD]. Who approves: [APPROVER].

Provide the layout with columns for date, start, end, break, hours worked, project and an approved checkbox, and sample rows I can paste. Formulas: hours worked from start and end times, adding one day when the end time is before the start (22:00 to 06:00 is 8 hours); subtotals per project with SUMIF; weekly totals; and overtime above the threshold, with worked examples: Mon 09:00 to 17:30 with a 0:30 break is 8.0 hours, Tue 22:00 to 06:00 with a 0:30 break is 7.5. Add data validation for the project and time format and a protected formula column [VERIFY behaviour].

Rounding rules are for my employer to confirm, not assumed. Describe how the approver reviews and how corrections are recorded, and add a privacy note about who can see other people's hours.

Fill in before use

Optional: type your details and the prompt above updates. Nothing is saved or sent.

Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.

See an example result (fictional data)
Invented rows. Mon 09:00 to 17:30, break 0:30: 8.5 - 0.5 = 8.0 hours. Tue 22:00 to 06:00, break 0:30: 8.0 - 0.5 = 7.5 hours. Weekly total = 15.5 hours. Overtime above 40 hours: none. Formula idea for hours with a break: =IF(C2<B2,C2+1-B2,C2-B2)*24-D2*24 where B is start, C is end and D is the break as a time; shown here as a pattern to test in your own sheet [VERIFY]. Overtime example: a week of 44 hours with a 40-hour threshold gives 4 hours of overtime. Approval: the manager ticks the box after checking the total.

Illustrative only, made-up data. Your results will differ and must be reviewed.

Related prompts