Use a time calculator for timesheets and study logs. Add durations, convert decimal hours, and handle overnight shifts with clear examples.
A time calculator helps you add or subtract hours, minutes and seconds without mixing up base‑60 minutes and base‑10 decimals. You finish a shift at 17:30, started at 09:00, took 30 minutes for lunch, and payroll wants a decimal. Or you have three video clips at 2:15, 4:40 and 1:05 and need the total runtime. Both jobs are time calculation.
In 2026, freelancers, managers and students still trip on the same trap: writing 7:30 as 7.30 and then multiplying by an hourly rate. This guide shows the clean methods, the overnight fix, and which free browser tool to open for each case.
To add or subtract durations, convert to seconds (or minutes), do the maths, convert back to hh:mm:ss.
To find hours between two clock times, subtract start from end, add 24 hours if the shift crosses midnight, then subtract unpaid breaks.
For payroll decimals, minutes ÷ 60. So 8:45 → 8.75, not 8.45. Never type 8.30 when you mean eight hours thirty minutes (that is 8.50).
Use the free time calculator for duration maths and the hours calculator for start/end + break.
Cross-check weekly totals once in decimals and once in hours:minutes. If they disagree, you dropped a carry.
Minutes wrap at 60, not 100. That single fact causes most spreadsheet mistakes. People write 7 hours 30 minutes as 7.30, then multiply by an hourly rate and underpay or overpay. The correct decimal for 30 minutes is 0.5, so the value is 7.5.
Microsoft’s support article on adding or subtracting time in Excel shows the same idea inside spreadsheets: times are fractions of a day, and totals over 24 hours need a special [h]:mm format. Google’s Docs Editors Help covers date and time functions for Sheets users who prefer formulas.
Pick seconds if you care about hh:mm:ss. Pick minutes if you only need hours and minutes.
Example — add 2:45:30 + 1:20:15
2:45:30 → 2×3600 + 45×60 + 30 = 9930 seconds
1:20:15 → 3600 + 1200 + 15 = 4815 seconds
Sum = 14745 seconds
14745 ÷ 3600 = 4 hours remainder 945 seconds
945 ÷ 60 = 15 minutes remainder 45 seconds
Same conversion, then subtract. If the result is negative, you either swapped the inputs or you are measuring a deficit (for example, remaining allowance). Showing a minus sign is clearer than silently swapping the times.
1:30:00 — one hour thirty minutes
90:00 — ninety minutes (mm:ss style on some tools)
5400 — raw secondsA good calculator accepts the common ones and states which it assumed. On mfaysal’s time calculator, mm:ss and hh:mm:ss both work; a single number is treated as seconds.
This is the timesheet problem — and where the hours calculator shines.
Formula: (end minutes from midnight − start minutes from midnight) − unpaid break minutes
Example — 09:00 to 17:30 with a 30-minute lunch
09:00 → 9×60 = 540
17:30 → 17×60 + 30 = 1050
Span = 1050 − 540 = 510 minutes (8 h 30 m)
Minus break 30 → 480 minutes
If you work 22:00 to 06:00, the end is “smaller†than the start on a 24-hour clock. Add 24 hours to the end before subtracting:
22:00 → 1320 minutes
06:00 + 24h → 360 + 1440 = 1800
Span = 480 minutes = 8 hours
UK guidance on working time (including limits and rest) is summarised by ACAS on working hours and GOV.UK on maximum weekly working hours. Those pages are about legal limits and rest rights — not a calculator — but they are the right official references when you are designing rotas, not just doing arithmetic.
| Hours:Minutes | Decimal hours |
| --- | --- |
| 7:00 | 7.00 |
| 7:15 | 7.25 |
| 7:30 | 7.50 |
| 7:45 | 7.75 |
| 8:06 | 8.10 |
| 8:20 | 8.33 (≈) |
| 8:45 | 8.75 |
|---|
Rule: decimal part = minutes ÷ 60.
Reverse: minutes = decimal part × 60. So 0.75 → 45 minutes.
Writing 8.30 when you mean eight hours thirty minutes. In decimal hours, 8.30 means 8 hours + 0.30×60 ≈ 18 minutes, i.e. about 8:18. Payroll that multiplies 8.30 by an hourly rate will not match a timesheet that intended 8:30.
You can total a week two ways and cross-check.
Decimal path: Mon 8.00 + Tue 8.00 + Wed 7.75 + Thu 8.75 + Fri 6.00 = 38.5
Hours:minutes path: 8:00 + 8:00 + 7:45 + 8:45 + 6:00 → hours 37, minutes 90 → 38:30, which is the same as 38.5.
If the two disagree, you dropped a carry or used a fake decimal. Fix that before you multiply by a rate.
For summing many hh:mm:ss clips (editors, podcasters, course creators), duration mode on the time calculator is faster than converting each line by hand. When you need the mean of several performances, use the average time calculator instead.
Freelancers often track blocks like 1:20 + 0:45 + 2:10. Convert once, sum once, then decide whether your invoice wants decimals or h:mm. Clients who see 3.75 hours understand it when you also show 3 h 45 m in the narrative line.
Students logging revision can do the same weekly. An honest log beats a vague “I studied a lot.†Pair duration maths with a countdown online timer when you want structured Pomodoro-style blocks, then log what actually happened with an online stopwatch or written end time. For lap-style study sessions, the stopwatch how-to walks through Start / Lap / Copy.
If A2 is start and B2 is end on the same day:
Display as duration: format h:mm
=(B2-A2)*24Microsoft documents difference patterns in Calculate the difference between two times. For totals that can exceed 24 hours, use a custom format like [h]:mm so 28 hours does not wrap to 4:00.
Keep break minutes in their own column. Formula clarity beats hiding the lunch deduction inside a magic number.
Store the end as a full date-time, or add 1 when end =IF(B2<A2,B2+1,B2)-A2
Hours between 09:00 and 17:30 is clock maths. “How many working days until 15 December?†is calendar maths and may exclude weekends and bank holidays. For UK-style business day counts, use the working days calculator and official holiday lists such as GOV.UK bank holidays. Do not force that problem into a time-of-day calculator.
Clips: 0:48, 3:12, 5:05, 2:30 (mm:ss). Seconds: 48 + 192 + 305 + 150 = 695 → 11:35 total. Useful for YouTube descriptions and course platforms that ask for duration.
21:45 start, 07:15 end, 45-minute unpaid break. End +24h path → span 9 h 30 m → minus 45 m → 8 h 45 m = 8.75.
Timesheet says 8:20. Someone typed 8.20 into payroll. True decimal ≈ 8.333. At a typical hourly rate, the error is small once and painful across a team and a year.
| Need | Tool |
| --- | --- |
| Add/subtract hh:mm:ss or convert units | Time calculator |
| Start/end clock times + break | Hours calculator |
| Mean of many lap times | Average time calculator |
| Days ↔ hours | Days to hours converter |
| Count-up while you work | Online stopwatch |
| Countdown focus block | Online timer |
|---|
All of them run in the browser. Nothing from your timesheet needs to leave your device for the arithmetic itself. Browse the full hub at free tools.
Write times in 24-hour clock when you can.
Record unpaid breaks explicitly.
Convert to decimals only at the end.
Cross-check one day per week with manual minutes.
Rounding every punch to the nearest 15 minutes can be fine when applied fairly, but one-sided rounding that always hurts workers can create underpayment problems. Policy clarity matters as much as the calculator.
15 minutes = 0.25 h
20 minutes ≈ 0.33 h
30 minutes = 0.5 h
40 minutes ≈ 0.67 h
For 10 minutes use ≈0.17 (or 1/6). For 5 minutes use ≈0.08. Memorising the quarter-hour set prevents most phone-calculator typos when you are standing at a rota whiteboard.
Date:
Start:
End:
Unpaid break (min):
Gross minutes:
Net minutes:
Net hh:mm:
Decimal hours:
Notes:Fill it once per day for a week. By Friday the pattern of your real working rhythm is obvious — and so are the days you forgot to log lunch.
Crossing a daylight saving change during a multi-day on-call window is a timezone problem as much as a duration problem. If your “48-hour duty†spans the night clocks go back, local civil time and elapsed UTC seconds diverge. For meetings and zone conversion, use the timezone converter and the companion timezone & world clock guide. For pure elapsed duration independent of zones, count in UTC or in seconds from a single reference instant.
Try these without looking at the answers first:
Add 3:40:00 + 2:35:20.
08:50 to 17:10 with 40 minutes unpaid break — net hours and decimal.
Convert 6.25 decimal hours back to hours and minutes.
Answers: (1) 6:15:20 (2) 7 h 40 m ≈ 7.67 (3) 6 h 15 m (4) 7 h 15 m = 7.25. If you matched all four, your process is solid. If not, slow down at the conversion step — that is where almost everyone slips.
Sometimes the input is days, not clock times. Three and a half days of server uptime is 3.5 × 24 = 84 hours. Thirty days of continuous logging is 720 hours. For quick day↔hour jumps, the days to hours converter saves a manual multiply. Keep contracts separate: a “day†of annual leave is often a working day of 7.5 or 8 hours, not 24.
Need “90 days from today†for a probation end or visa letter? That is the date calculator, not a time-of-day tool. Keep duration, clock-span, and calendar-date problems in separate mental buckets and you will pick the right calculator the first time.
Average handling time (AHT) mixes talk time and after-call work. Teams usually sum many mm:ss samples and divide. That is average-time maths, not shift maths. Mixing the two in one sheet — decimal shift hours in the same column as raw call durations — creates silent errors. Keep columns typed: duration, clock time, or decimal hours, never a vague “time†without a unit header.
When the samples are lap-style performance times, the average time calculator is the safer path. When the samples are shift punches, stay with the hours calculator.
Once net hours are correct, overtime rules multiply them. Time-and-a-half on a fuzzy 8.30-vs-8.50 error spreads into every premium. Finance teams that reconcile timesheets against badge logs look for patterns: always-rounded punches, missing breaks, or overnight shifts entered as negative spans. Clean arithmetic will not fix a bad policy, but it makes honest policies auditable.
If you supervise a team, publish a one-page “how we count hours†note with three examples: standard day, overnight, and short shift with long break. New hires stop guessing. Link the note to the free time calculator so people can self-check before they escalate.
A two-minute demo helps: show 7:30 → 7.5 on a whiteboard, then show why 7.30 is wrong. Ask people to convert 20 minutes. Most say 0.20 until you divide 20 by 60. That lightbulb moment prevents months of quiet errors.
Follow with a phone-calculator drill: convert 8:45, 6:15 and 9:20. Write both the clock form and the decimal on the same sticky note. Stick it near the rota whiteboard for a week.
Browser calculators are for checking. The system of record remains your HR or time-and-attendance platform. When the two disagree, investigate inputs (wrong end time, forgotten break) before assuming the platform is broken. Export one raw day and recompute by hand with the hours calculator as a referee.
Accessibility of timesheet sheets also matters. Use clear column headers: “Start (24h)â€, “End (24h)â€, “Break minutesâ€, “Decimal hoursâ€. Colour the decimal column differently so nobody types clock minutes into it. Protect formula cells. These UX details beat another training email.
Add daily decimals, then round once at the pay-period end according to policy — not after every day — unless your system requires daily rounding. Intermediate rounding creates penny drifts that annoy everyone during audits.
Double-entry check for freelancers: write the hours in words on the invoice line (“twelve and a half hoursâ€) as well as the decimal. Clients catch typos faster when both forms appear. Attach a one-line method note once: “Decimals = minutes÷60.†It reduces back-and-forth.
If you are measuring an open-ended task right now, start the online stopwatch, copy the total when you finish, then paste it into the time calculator or your log. The stopwatch guide covers laps and shortcuts. If the work spans multiple cities or overnight on-call windows, confirm civil times with the timezone converter before you call the span “eight hours.â€
Capture punches in 24-hour clock (paper, badge, or app).
Mark unpaid breaks in their own column the same day.
Run the hours calculator for overnight or awkward spans.
Convert to decimals only when payroll asks for them.
Spot-check one random day with the time calculator duration mode.
That six-step loop takes minutes and prevents the Friday-night scramble. Pair it with the timezone meeting guide if your team logs hours across countries and DST borders.
Convert both to minutes from midnight, subtract, then subtract unpaid breaks. Use the overnight adjustment when end is earlier than start.
45 ÷ 60 = 0.75. So 8:45 → 8.75.
No. 8.30 decimal hours is about 8:18. Eight hours thirty minutes is 8.50.
Sum the times and format the result as [h]:mm so hours do not wrap at 24. See Microsoft’s add or subtract time guide.
Yes. Add 24 hours to the end time (or tick overnight on the hours calculator) before subtracting the start.
Do not average the minute and second fields separately. Convert each time to seconds, average, convert back — or use the average time calculator.
No. They help you check arithmetic. Your employer’s system, contract and local law decide what counts as paid time.
Start with ACAS working hours and GOV.UK maximum weekly working hours.
Time calculation in 2026 is still conversion plus careful subtraction. Respect base‑60 for minutes, use true decimals for payroll, and separate “duration maths†from “clock-to-clock shift maths.†With those habits — and free browser tools for durations and hours between times — you can finish a timesheet or a video total without the usual off-by-half-hour surprises.
A practical UK guide to removing the background from a photo for free: step-by-step instructions, what transparent PNG means, how to spot fake 'free' tools, privacy under UK GDPR, and tips for Amazon, eBay and Vinted product photos.
Convert meeting times across zones with DST-aware tools, read a world clock, and schedule fair slots for London, New York and Dhaka teams.
Learn how to use a free online stopwatch with start, lap, stop and reset. Record splits, copy results, and time training in your browser.
To check an SSL certificate expiry date, click the padlock or site-information icon in your browser and read the Expires on date, or pipe openssl s_client into openssl x509 -noout -enddate. On Windows, PowerShell reads the NotAfter date, and -checkend warns you before it lapses.