What it's for
- A quick log of time on a task, a case or a piece of work.
- People who do not need clients, projects, rates or breaks.
- Adding up how long something took.
What's inside
- How to use
- Short instructions and the colour key.
- Time log
- Total time at the top, then 200 rows of date, started, stopped, duration in hours and minutes, decimal hours, running total and what you did.
Preview
| Date | Started | Stopped | Duration | Decimal | Running total |
|---|---|---|---|---|---|
| 1 Mar 2027 | 09:00 | 10:15 | 1:15 | 1.25 | 1:15 |
| 1 Mar 2027 | 10:30 | 12:00 | 1:30 | 1.50 | 2:45 |
| 1 Mar 2027 | 13:00 | 15:45 | 2:45 | 2.75 | 5:30 |
Total time: 5 hours 30 minutes, or 5.50 decimal hours. A stop time after midnight counts to the next morning, so 22:00 to 01:30 is 3:30.
How to use it
- Type the date and the time you started and stopped for each piece of work.
- Add what you did in the last column.
- Duration, decimal hours and the running total appear for you.
- Read the total time at the top.
- To add a break, leave a gap between one entry's stop and the next one's start.
The formulas, explained
- Duration
-
=IF(OR(B4="",C4=""),"",MOD(C4-B4,1))The time between started and stopped as a fraction of a day, even after midnight. It is formatted as hours and minutes.
- Decimal hours
-
=IF(D4="","",D4*24)A day is 24 hours, so the duration times 24 is the time in decimal hours.
- Running total
-
=IF(D4="","",SUM(D$4:D4))Adds up the durations from the first row down to this one.
Every formula uses functions that Excel, Google Sheets and LibreOffice all have. There are no macros or scripts.
Questions
How is this different from a timesheet?
It has no breaks, approval, clients, tasks or rates. It is only a log of when you worked, with a running total.
Why does the total show over 24 hours?
The total uses a format that keeps counting hours, so 30 hours shows as 30:00, not 6:00.
Can I see the time in decimal hours?
Yes, the Decimal hours column shows each entry as decimal hours, and the total at the top does too.
What if I forget to stop?
Type the time you actually stopped. A stop time earlier than the start is counted as the next day, so check for a mistake if a duration looks very long.
Does it work in Google Sheets?
Yes. Upload it with File > Import in Google Sheets. It only uses functions both programs have (IF, OR, MOD and SUM). It also opens in LibreOffice.
About this template
Last reviewed 15 November 2026.
Changes: 15 November 2026: first published.
Free to use and change in your own business. Please don't resell the files or publish them as your own. More free templates.