# Get a weekly timesheet just by telling AI what you're working on > No more rebuilding a month of hours from memory. You type 'starting the Tidewell report' and it does the math. Keep one chat or project as your time log. Tell it what you're starting and stopping in plain words, and at week's end it hands you a timesheet table ready to paste into your spreadsheet. - Page: https://thesolocreators.com/prompts/log-billable-hours-by-telling-ai-as-you-go/ - Category: Put your business on autopilot - Made for: Consultants, Coaches, Small business owners - Works in: ChatGPT, Claude, Gemini - Time: A few seconds per entry, then 2 minutes a week - Effort: A few steps - Note: Long chats can lose track. Export the table every week and start a fresh chat each month. - Published: 2026-11-17 ## Can I track my billable hours just by telling ChatGPT? Yes. Keep one ChatGPT, Claude or Gemini project or chat as your time log, send short start and stop notes, and ask for a weekly timesheet table in your columns. If you bill by the hour, ask for daily summaries so mistakes get caught the same day. If you only need totals for invoices, the weekly table is enough. Export it every week, since very long chats can lose track of early entries. ## The prompt Fill in the parts in [square brackets], or leave them and the AI will ask you for them. ```text Be my time log for client work. I'll send short notes through the day, like 'start Tidewell strategy call 10:15' and 'stop 11:00'. If I forget a time, ask me instead of guessing. My clients: [YOUR CLIENTS, e.g. Tidewell, Harbor Dental, Oak & Co] My timesheet columns: [YOUR COLUMNS, e.g. date, client, task, start, end, hours] Round time to: [ROUND TO, e.g. nearest 15 minutes] Rules: - Keep a running list of every entry and never change past entries unless I say so. - Flag overlaps, duplicates and anything left open over 3 hours. - After each entry, reply with one line confirming it. When I type 'daily summary', give me today's entries and total hours by client. When I type 'weekly timesheet', give me one table in my exact columns, sorted by date, with totals by client at the bottom, ready to paste into a spreadsheet. ``` ## Step by step 1. Create a project or one long chat called Time log. 2. Paste the setup prompt below and fill in the brackets. 3. Type short notes as you work, like 'start Tidewell call' and 'done'. 4. On Friday, type 'weekly timesheet' and paste the table into your spreadsheet. ## What you'll get A running time log in one chat, daily summaries on request, and a paste-ready weekly timesheet with totals per client. ## Good to know **Can I track my billable hours just by telling ChatGPT?** Yes. Keep one ChatGPT, Claude or Gemini project or chat as your time log, send short start and stop notes, and ask for a weekly timesheet table in your columns. If you bill by the hour, ask for daily summaries so mistakes get caught the same day. If you only need totals for invoices, the weekly table is enough. Export it every week, since very long chats can lose track of early entries. **Which AI tools does this work in?** It works in ChatGPT, Claude and Gemini. On this page, ChatGPT and Claude open with your prompt already typed in. Long chats can lose track. Export the table every week and start a fresh chat each month. **How long does it take?** A few seconds per entry, then 2 minutes a week. It's rated "A few steps". There are 4 steps, listed above. **What do I need before I start?** Just your details for 3 blanks: your clients, your columns and round to. You can skip any, and your AI will ask for them. **What will I get back?** A running time log in one chat, daily summaries on request, and a paste-ready weekly timesheet with totals per client. Idea spotted on Reddit, shared by u/Heal_Me_Today: https://www.reddit.com/r/ChatGPT/comments/1xx5vhg/chat_gpt_helped_me_build_a_one_button_macro_for/. The prompt is The Solo Creators' own version. ## Go further Ready-made skills in the Solo Creators AI Studio (https://thesolocreators.com/studio/) that fit this: Second Brain (Give your AI a memory it reads across every project, so it finally knows your business); Watch It For Me (Drop any video link and get the step-by-step playbook, the full timestamped transcript, and the best quotes. Without watching it). From AI Use Cases and Prompts by The Solo Creators: https://thesolocreators.com/prompts/. Free to use; please link back to the page when you share it.