03
Timesheet
One row per driver-day: start, end and break. Hours worked are calculated by formula.
Excel template
Driver Timesheet Excel Template
An Excel file that works out shift hours, shifts running past midnight and per-person totals. Built for drivers, works for any employee. Download it without signing up.
Download the template (.xlsx)
No sign-up, no email. The file downloads directly.
The same timesheet, two ways of working.
seferi-driver-timesheet-template.xlsx
.xlsxTimesheetSummaryHow to use
DriverPlateDateHours workedOvertime hours
Columns with a blue header are formulas; they fill themselves. Rows arrive empty.
The same sheet — days and per-diem come from the trip record.
- AutomaticDays on the road and per-diem come from the trip record.
- One recordDriver, plate and trip stay in the same place.
- The month-end total is ready without waiting.
No need to enter your drivers again.
This job in Seferi
Drivers see each job step by step in the app
From the product film · narrated in Turkish, with captions
Three sheets in the file
All you enter is one row per driver-day; the hour calculation and the per-driver totals follow on their own.
03
Summary
Period totals and a per-driver breakdown. Type a driver's name and that driver's totals appear.
03
How to use
Which columns are formulas, how night shifts are handled and why there are no preset rates — all inside the file.
Columns in the template
Columns with a blue header are formulas — do not overwrite them. The rest is your data.
Who, when
- Driver
- Plate
- Date
- Day type
Hours
- Start
- End
- Break (hours)
- Hours worked — formula
- Overtime hours — formula
Travel and pay
- Days away
- Per diem
- Additional pay
- Notes
No cell carries a pre-filled amount or rate. You enter the normal working hours per day; leave it blank and the overtime column stays blank too.
You have seen the columns. The file itself is one click away — no sign-up, no email.
Where does Excel stop?
The arithmetic is not the problem: Excel handles this, and the template exists to make that easier.
The limit starts at data entry. The hours come from the driver while the file sits on your desk; in between there are calls, messages and paper collected in the evening. Every row corrected at month end pushes payroll back another day.
The second limit is concurrency. Two people cannot edit the same file at once, and once two copies are circulating there is no answer to which one is right.
The third is context. A timesheet on its own is just a number; it means something when it sits next to the trip, the vehicle and what that trip cost. Joining data that lives in separate files is manual work done at month end.
Read next
01
How to Calculate Freight Cost: A Carrier's Real Cost Formula
Freight cost is not the price quoted to the shipper; it is the sum of the ten cost items a carrier covers to make a trip happen.
02How to Calculate Profit per Truck
The vehicle is what earns, not any single trip: the full per-truck chain from revenue to net profit, item by item, with a worked monthly example.
03Where Does Excel Break Down in Trip Tracking?
Excel is the right tool at small scale; the problem is never the file itself, but what happens once more than one person writes into it.
Other free templates
Freight Tracking Excel Template
Profit per trip, cost per kilometre and the empty-kilometre ratio, formulas included.
Dispatch Plan and Tracking Sheet
Which load is on which vehicle, the fill rate, shipment status, and dispatches with no vehicle yet.
Freight Quote Form (Word)
The quote document you send a customer — it also asks what the price includes.
Quote Comparison Table
Levels three carriers onto one basis: not the headline rate but a comparable total with excluded items added.
Frequently asked questions
What people ask most before downloading.
Does the template calculate the overtime premium?
No, deliberately not. The premium rate and the weekly threshold depend on local law and the employment contract, and a wrong rate baked into a template causes real payroll loss. The template gives you the hours; you apply the rate.
Are shifts running past midnight handled correctly?
Yes. If the end time is earlier than the start, the formula adds a day, so 22:00–06:00 counts as eight hours. Whatever you put in the break column is deducted from that total.
Do I need to sign up to download it?
No. We do not ask for an email and there is no form. The file downloads as soon as you click.
How many rows is the template set up for?
Formulas are pre-filled for 200 rows. If you need more, copy the last row downwards.
Is it only for drivers, or can I use it for other staff?
You can use it for anyone; the hour maths does not care who it is kept for. Start, end, break and the past-midnight logic work the same for warehouse, workshop or office staff. Three columns are driver-specific: Plate, Days away and Per diem. Leave them empty or rename them to a line of your own — the formulas do not depend on them, only Hours worked and Overtime are calculated.
Are a timesheet, an attendance sheet and a shift log different things?
Three names for the same thing. An attendance sheet usually means the monthly grid with people down the side and days across the top; a log means one row per shift. This template uses the second form: one row per shift. The reason is arithmetic — without holding the past-midnight shift and the break on their own row, hours worked do not come out right. The monthly per-person total is on the Summary sheet, so the grid view you expect is in the file too.
Is there a filled-in example?
No, the file ships empty on purpose. A worked example makes the hours and amounts in it look like a recommendation, and this template carries no preset rate or amount because overtime premiums and per diem depend on local law and the employment contract. The "How to use" sheet explains which columns are formulas and where to enter your normal daily hours; until you enter that setting, the overtime column stays empty.
Calculators, Excel templates and reference tables in one place.
All free resourcesLet the driver log the hours
In Seferi the timesheet comes from the driver's mobile app and lives on the same record as the trip and the vehicle. Manual entry and the second copy disappear.