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.
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.
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
Type a year and a month and the calendar redraws itself: weekends shaded, today blue, other months greyed, and your events written into the right days from a list. Pro adds the whole year on one sheet, a week planner, holidays, and a formulas walkthrough. No macros.
A week of shifts: people down the side, seven days across, a shift code per cell from a dropdown — hours and pay per person come from the code table, headcount per day is counted. Pro adds coverage against required staffing per shift, payroll with overtime, and a formulas walkthrough. No macros.
A to-do list that knows what's late: task, category, priority, due date and a ✓ when done; status (Done, Overdue, Today, Soon, Open), days left and a progress bar are calculated. Pro adds a Focus sheet listing what's overdue and due this week, a Board with counts per category, person and priority, and a formulas walkthrough. No macros.