Type in and out as times and a break in hours; hours and overtime are calculated, night shifts past midnight included. Pro adds a log with projects and hourly rates, billable amounts per project and per week, distinct days worked, and a formulas walkthrough. No macros.
Seven days: in, out, break, hours, overtime above a daily threshold you set, weekly totals, average per worked day. (Free file.)
One row per block of work: date, project from a dropdown, in, out, break — hours and billable amount calculated per row, an unknown project flagged; totals for hours, billable hours, amount and billable share.
Hours, share, rate, amount and entry count per project, with bars.
Twelve weeks from a date you set: hours, weekly overtime, billable hours and amount, distinct days worked.
Projects with hourly rate and billable flag; weekly overtime threshold.
Seven formulas explained, including the distinct-days count.
Every workbook is recalculated in LibreOffice and by a second, independent formula engine on the sample data; the totals are compared with numbers worked out outside any spreadsheet, and every formula cell is scanned for errors. We don't run Excel itself on the build machine, so this says built for, not tested in — open the live preview to see the numbers the formulas produce.
What that means app by app: in Google Sheets, in Apple Numbers, in LibreOffice Calc.
The home page and its CSS — enough to publish a one-pager. A credit link stays in the footer.
Every page, the Pro-only pages, the source files, no attribution, and 12 months of updates and email support.
Use it for unlimited personal and commercial purposes, including client work.
Do not resell the spreadsheet itself, alone or in a bundle.
Tracking hours worked is a subtraction that goes wrong at midnight; this sheet gets it right in every row.
A time in Excel is a fraction of a day, so hours are (out − in) × 24 minus the break. If
out is earlier than in, the shift crossed midnight and the formula adds a day first. The free
Week sheet does that for seven days with a daily overtime threshold; the Pro Log does it per
block of work with a project attached.
Each project on Setup has a rate and a billable flag. The Log multiplies hours by the rate per row; Projects sums per project; Week sums per week with overtime above the weekly threshold and counts the distinct days you worked — a SUMPRODUCT that weights each row by one over how many rows share its date, explained on the Formulas sheet.
The build recalculates the workbook in LibreOffice and in a second, independent engine on the sample log and compares fifteen values — hours for a row with a break, totals, billable amount, a project’s hours and amount, a week’s hours and distinct days, the free file’s daily overtime — against numbers computed outside Excel.
First release
Chores down the side, seven days across, and a rotation that says whose turn each one is this week — change the date and the chart re-deals itself. Ticks, minutes and what's still owed are calculated, and each person's share is worked out on minutes, not on the number of chores. Pro adds eight weeks of the rotation printed ahead and a People sheet comparing everyone against a fair share. No macros.
A week of meals picked from your recipe list, with cost and prep minutes per day worked out from the recipes, and a shopping list with ticks. Pro moves the recipes to their own sheet with categories, and the shopping list to one with aisles and what's left per aisle. No macros.
One row per day of the trip: dates from the start date, where you are, what you plan, and what it costs by kind. Daily and trip totals, per day and per person, against a budget. Pro adds a Budget sheet by kind, Bookings with confirmations and what's still to pay, and a Packing checklist. No macros.