How to Make a Time Log in Excel (Step by Step)
Build a DIY time log in Excel: Date, Start, End, Task, Duration with =(End-Start)*24, plus data validation and a daily total.
You do not need a specialty app to keep a time log in Excel. A blank workbook, five headers, correct time formats, and one duration formula will beat another abandoned timer login — if you build the sheet in order.
For template selection and cluster links, see Daily Time Log Excel Template.
Key takeaway: Build Date → Start → End → Task → Duration with =(End-Start)*24, format Duration as Number, guard blank rows with IF, then add optional Client and a daily SUM.
Before You Type Headers
Decide what the log is for this month:
- Billable freelancing narrative
- Personal productivity audit
- Light team handoff notes
Do not invent biweekly overtime rules on day one. That is a timesheet project. Keep this build as a daily activity log.
Gather: today’s date, two sample tasks, and whether you invoice by client name.
Build the Sheet
Create a DIY time log in Excel
- Open a new workbook. Bold row 1: Date | Start | End | Task | Duration | Client | Notes.
- Format Date as Date; Start and End as Time; Duration as Number with 2 decimals; Client as text.
- Freeze the header row.
- Row 2 sample — Date = today, Start = 9:00 AM, End = 10:30 AM, Task = “Draft proposal”, Client = “Acme”.
- Duration formula in E2 — with Start in B2 and End in C2 use
=(C2-B2)*24. - Blank-row guard —
=IF(B2="","",(C2-B2)*24)so unused rows stay empty. - Drag formulas down 40 rows, or press Ctrl+T to make an Excel Table.
- Data validation on Task or Client (optional) — a short list prevents spelling drift.
- Daily total — below the table or in a dashboard cell:
=SUM(E2:E50). - Save as
time-log-YYYY-MM.xlsx.
Microsoft’s public timesheet help and countless tutorials use the same (End-Start)*24 pattern. Hubstaff’s time-log primers add the habit layer: log consistently, then review.
Daily Entry Habits
- Enter the block when you switch tasks, not at midnight.
- Keep Task labels short and repeatable.
- Never type over Duration cells after formulas are set.
- If you take lunch, either log a Break row or subtract break minutes in Notes — pick one method.
Warning: Active filters can hide rows and make the day look under-logged. Clear filters before you trust any total.
When DIY Stops Being Fun
If you spend more time repairing formats than recording work, switch to a structured template with Start Here instructions. The Daily Time Log Excel Template (PlanoNest — disclosure: we sell it) is a one-time-purchase workbook aimed at daily logging rather than payroll time cards. Live pricing sits on the product page.
Stretch Goals (Optional)
- Pivot Table by Client for monthly billing.
- Conditional formatting when Duration > 3 (possible missing breaks).
- Second sheet “Legend” documenting activity codes.
Skip stretch goals until you have ten honest days.
Keep the log boring on purpose
Fancy dashboards feel productive and then go stale. A durable daily time log is slightly boring: stable headers, predictable activity words, and Duration cells that always mean the same thing. Resist sparkline art unless your team already uses that language in standups.
Name archive files with months, not "Final_v7_REAL". If you need history for client disputes, keep monthly snapshots in a read-only folder instead of one immortal tab that never ends.
Mobile editing is a bonus, not the design center. Optimize for the laptop review you actually do, then confirm Google Sheets behavior if someone must add a row from a phone.
Keep the log boring on purpose
Fancy dashboards feel productive and then go stale. A durable daily time log is slightly boring: stable headers, predictable activity words, and Duration cells that always mean the same thing. Resist sparkline art unless your team already uses that language in standups.
Name archive files with months, not "Final_v7_REAL". If you need history for client disputes, keep monthly snapshots in a read-only folder instead of one immortal tab that never ends.
Mobile editing is a bonus, not the design center. Optimize for the laptop review you actually do, then confirm Google Sheets behavior if someone must add a row from a phone.
Keep the log boring on purpose
Fancy dashboards feel productive and then go stale. A durable daily time log is slightly boring: stable headers, predictable activity words, and Duration cells that always mean the same thing. Resist sparkline art unless your team already uses that language in standups.
Name archive files with months, not "Final_v7_REAL". If you need history for client disputes, keep monthly snapshots in a read-only folder instead of one immortal tab that never ends.
Mobile editing is a bonus, not the design center. Optimize for the laptop review you actually do, then confirm Google Sheets behavior if someone must add a row from a phone.
Keep the log boring on purpose
Fancy dashboards feel productive and then go stale. A durable daily time log is slightly boring: stable headers, predictable activity words, and Duration cells that always mean the same thing. Resist sparkline art unless your team already uses that language in standups.
Name archive files with months, not "Final_v7_REAL". If you need history for client disputes, keep monthly snapshots in a read-only folder instead of one immortal tab that never ends.
Mobile editing is a bonus, not the design center. Optimize for the laptop review you actually do, then confirm Google Sheets behavior if someone must add a row from a phone.
Keep the log boring on purpose
Fancy dashboards feel productive and then go stale. A durable daily time log is slightly boring: stable headers, predictable activity words, and Duration cells that always mean the same thing. Resist sparkline art unless your team already uses that language in standups.
Name archive files with months, not "Final_v7_REAL". If you need history for client disputes, keep monthly snapshots in a read-only folder instead of one immortal tab that never ends.
Mobile editing is a bonus, not the design center. Optimize for the laptop review you actually do, then confirm Google Sheets behavior if someone must add a row from a phone.
Keep the log boring on purpose
Fancy dashboards feel productive and then go stale. A durable daily time log is slightly boring: stable headers, predictable activity words, and Duration cells that always mean the same thing. Resist sparkline art unless your team already uses that language in standups.
Name archive files with months, not "Final_v7_REAL". If you need history for client disputes, keep monthly snapshots in a read-only folder instead of one immortal tab that never ends.
Mobile editing is a bonus, not the design center. Optimize for the laptop review you actually do, then confirm Google Sheets behavior if someone must add a row from a phone.
Keep the log boring on purpose
Fancy dashboards feel productive and then go stale. A durable daily time log is slightly boring: stable headers, predictable activity words, and Duration cells that always mean the same thing. Resist sparkline art unless your team already uses that language in standups.
Name archive files with months, not "Final_v7_REAL". If you need history for client disputes, keep monthly snapshots in a read-only folder instead of one immortal tab that never ends.
Mobile editing is a bonus, not the design center. Optimize for the laptop review you actually do, then confirm Google Sheets behavior if someone must add a row from a phone.
Keep the log boring on purpose
Fancy dashboards feel productive and then go stale. A durable daily time log is slightly boring: stable headers, predictable activity words, and Duration cells that always mean the same thing. Resist sparkline art unless your team already uses that language in standups.
Name archive files with months, not "Final_v7_REAL". If you need history for client disputes, keep monthly snapshots in a read-only folder instead of one immortal tab that never ends.
Mobile editing is a bonus, not the design center. Optimize for the laptop review you actually do, then confirm Google Sheets behavior if someone must add a row from a phone.
Frequently Asked Questions
Why does my duration show 0.06 instead of 1.5?
You probably formatted Duration as Time or forgot *24. Excel stores time as fractions of a day; multiplying by 24 yields decimal hours.
How do I handle tasks that cross midnight?
For rare overnight blocks, split into two rows (before/after midnight) or use a more advanced formula. Most daily office logs should not cross midnight.
Can I share the DIY log in Google Sheets?
Yes. Upload the .xlsx or recreate formulas in Sheets. Avoid VBA if collaborators edit in the browser.
