Home › Blog › Time Calculator Guide

❤ Want to see our calculators more often in Google? Add us as a trusted source:

Time Calculator: Add, Subtract & Find Duration Between Times

Calculator200 Editorial Team — published 21 September 2026

A time calculator transforms the frustrating arithmetic of hours, minutes, and seconds into a single, accurate operation. Whether you are totalling a timesheet for payroll, calculating how long a project will take, converting between time zones for an international call, or simply working out the duration of a movie marathon, a dedicated time calculator removes the mental borrowing and carrying that makes manual time math so error-prone. Enter your values, choose your operation, and the result appears in clean hours and minutes — no spreadsheet formulas, no guesswork.

What Does a Time Calculator Do?

A time calculator performs four core operations on time values: addition, subtraction, duration calculation, and conversion. Each serves a distinct purpose, and together they cover virtually every time-related calculation you will encounter in daily life or professional work.

Addition combines two or more time durations. A freelancer billing three projects at 2 hours 45 minutes, 1 hour 20 minutes, and 4 hours 10 minutes needs a single total — 8 hours 15 minutes — without manually converting everything to minutes and back. Subtraction removes one duration from another, useful for calculating remaining time after a task has consumed part of a budgeted period.

Duration calculation finds the elapsed time between two clock points. If a shift starts at 9:45 AM and ends at 6:15 PM, the duration calculator returns 8 hours 30 minutes. This is the most common operation for work hours and project tracking. Conversion translates between time formats — decimal hours to hours and minutes, 12-hour to 24-hour, or one time zone to another. A free time calculator handles all four operations in a single interface, eliminating the need for separate tools or mental arithmetic.

How to Calculate Time Duration Between Two Times

The manual method for finding duration is straightforward once you understand the borrowing rule. Subtract the start time from the end time, column by column. If the minutes in the end time are smaller than the minutes in the start time, borrow one hour — which equals 60 minutes — from the hours column before subtracting.

Consider a shift from 9:45 AM to 6:15 PM. Convert to 24-hour format: 09:45 and 18:15. Subtract minutes: 15 − 45 = −30. Borrow one hour: minutes become 75 − 45 = 30, and hours become 17 − 9 = 8. The duration is 8 hours 30 minutes.

When the end time is earlier than the start time — an overnight shift from 10:30 PM to 6:15 AM, for instance — the period crosses midnight. Add 24 hours to the end time before subtracting. In 24-hour format, 22:30 to 06:15 becomes 30:15 minus 22:30, which equals 7 hours 45 minutes. A time duration calculator performs this adjustment automatically, so you do not have to remember the midnight rule.

The borrowing method works for any two times within a 24-hour cycle. For spans longer than 24 hours, include the date alongside the time and subtract the date-times directly. Spreadsheet software handles this natively when both cells contain full date-time values.

Adding and Subtracting Time in Hours, Minutes, and Seconds

Time addition follows the same carry logic as ordinary arithmetic, except the base is 60 rather than 10. Add the seconds first, then the minutes, then the hours. If seconds exceed 59, carry the excess into minutes. If minutes exceed 59, carry the excess into hours.

Example: 2 hours 45 minutes 50 seconds plus 1 hour 30 minutes 25 seconds. Seconds: 50 + 25 = 75, which is 1 minute 15 seconds — write 15, carry 1. Minutes: 45 + 30 + 1 = 76, which is 1 hour 16 minutes — write 16, carry 1. Hours: 2 + 1 + 1 = 4. The total is 4 hours 16 minutes 15 seconds.

Subtraction works in reverse. If seconds are negative after subtraction, borrow 60 seconds from minutes. If minutes become negative, borrow 60 minutes from hours. This is precisely the kind of arithmetic that invites mistakes when done in your head. A time calculator handles the carries and borrows without error, which matters most when the result feeds into payroll, billing, or scheduling decisions.

Time Calculator for Work Hours and Payroll

Payroll and billing are the two domains where time calculation accuracy carries direct financial consequences. An error of a few minutes per shift, multiplied across a workforce and a pay period, becomes a significant discrepancy.

The standard payroll workflow involves four steps. First, record clock-in and clock-out times for each shift. Second, subtract unpaid break durations. Third, total the net hours across the pay period. Fourth, multiply by the hourly rate to compute gross pay. A work hours calculator streamlines steps one through three, and many tools include an optional hourly rate field for step four.

Overnight shifts deserve particular attention. A nurse working 7:00 PM to 7:30 AM has worked 12 hours 30 minutes, not a negative figure. The calculator must detect that the end time is earlier than the start time and add 24 hours before subtracting. Similarly, shifts that span a daylight saving time transition require care: the actual elapsed time may be one hour more or less than the clock difference suggests. For legal and payroll purposes, the elapsed time — not the clock-face difference — is what counts.

ScenarioClock-InClock-OutBreakNet Hours
Standard day shift9:00 AM5:30 PM30 min8h 00m
Overnight shift10:00 PM6:00 AM0 min8h 00m
Split shift6:00 AM2:00 PM45 min7h 15m
Extended shift7:00 PM7:30 AM1 hr11h 30m

Time Zone Converter: Calculating Time Across Countries

Time zones add a layer of complexity that pure duration calculation does not address. When it is 3:00 PM in New York, what time is it in London, Mumbai, or Sydney? A time zone converter answers this by applying the UTC offset of each location and accounting for daylight saving time where it applies.

Coordinated Universal Time (UTC) serves as the reference point. India Standard Time is UTC+05:30 year-round. United States Eastern Time is UTC−05:00 in winter and UTC−04:00 in summer. The United Kingdom observes UTC+00:00 in winter and UTC+01:00 in summer. Australia's eastern states shift between UTC+10:00 and UTC+11:00 depending on the season. A time zone calculator applies these offsets and returns the corresponding local time without requiring you to look up the current DST status of each region.

Daylight saving time introduces a subtle trap: not all countries observe it, and those that do may change on different dates. The United States and Canada switch on the second Sunday in March and the first Sunday in November. The European Union switches on the last Sunday in March and the last Sunday in October. Australia's southern states switch in April and October. For roughly two weeks each spring and autumn, the offset between New York and London differs from the rest of the year. A time zone converter that maintains current DST rules handles this automatically; a static offset table does not.

12-Hour vs 24-Hour Time Formats

The 12-hour clock divides the day into two cycles of twelve hours, distinguished by AM and PM. Midnight is 12:00 AM, noon is 12:00 PM, and the cycle repeats. The 24-hour clock — also called military time — runs from 00:00 at midnight to 23:59 one minute before the next midnight, with no AM or PM designation.

Converting from 12-hour to 24-hour is mechanical. For AM times, keep the hour as-is, except 12:00 AM becomes 00:00. For PM times, add 12 to the hour, except 12:00 PM remains 12:00. So 2:30 PM becomes 14:30, and 11:45 PM becomes 23:45. The reverse conversion follows the same logic in reverse.

Aviation, military operations, and many healthcare systems use the 24-hour format exclusively because it eliminates ambiguity. A flight departing at 07:00 is unambiguously morning; a flight departing at 19:00 is unambiguously evening. A military time converter translates between the two formats instantly, which is useful when reading international schedules or filling out forms that require one format while your source data uses the other.

Calculating Time in Excel and Google Sheets

Spreadsheet software offers several approaches to time calculation, ranging from simple subtraction to specialised functions. The correct choice depends on whether the times fall within a single day, whether they cross midnight, and whether you need a formatted duration or a decimal number.

For same-day durations, subtract the start time from the end time and format the result as time:

=B2 - A2

For durations that cross midnight, use an IF formula that adds one day when the end time is earlier than the start time:

=IF(B2

To express the result as total hours rather than a clock duration, multiply by 24:

=(B2-A2)*24

To return total minutes, multiply by 1440 (24 hours × 60 minutes). To return total seconds, multiply by 86400 (24 × 60 × 60). These conversions are useful when the result needs to feed into a billing or payroll formula that expects a decimal number rather than a time value.

For adding durations together — for example, totalling a week of daily hours — use the SUM function and format the total cell as [h]:mm. The square brackets around the hour code tell Excel to display hours beyond 24 rather than rolling over to the next day. Without the brackets, 25 hours and 30 minutes would display as 1:30, which is misleading.

Google Sheets uses the same underlying time arithmetic as Excel. The same formulas apply, and the same formatting codes work. Sheets also supports the TIME(hour, minute, second) function for constructing time values from separate components.

Decimal Hours: Converting Between Formats

Decimal hours express time as a single number rather than a combination of hours and minutes. 2.5 hours means 2 hours and 30 minutes. 1.75 hours means 1 hour and 45 minutes. The format is common in billing systems, project management software, and payroll exports because it simplifies multiplication — 2.5 hours × $40 per hour = $100, no conversion required.

Converting from hours and minutes to decimal hours is a two-step process. Divide the minutes by 60 to get the decimal fraction, then add it to the hours. 3 hours 20 minutes becomes 3 + (20 ÷ 60) = 3.333 hours. Converting back requires multiplying the decimal portion by 60. 3.333 hours becomes 3 hours + (0.333 × 60) = 3 hours 20 minutes. A time to decimal calculator performs both conversions instantly, which is useful when reconciling a timesheet that records in H:MM against a payroll system that expects decimal hours.

Frequently Asked Questions

How do I calculate the time duration between two times?

Subtract the start time from the end time. If the end time is earlier than the start time, the period crosses midnight — add 24 hours to the end time before subtracting. Convert the result into hours and minutes by handling the borrow when minutes are negative. A time duration calculator performs all three steps automatically.

How do I add or subtract time in hours and minutes?

Convert all values to minutes, perform the addition or subtraction, then convert back to hours and minutes. For subtraction, if the minutes are negative, borrow one hour (60 minutes) from the hours column. A time calculator handles the carrying and borrowing so you can enter values directly in H:MM format.

How does a time zone calculator work?

A time zone calculator converts a time in one location to the corresponding time in another by applying the UTC offset of each zone. It accounts for daylight saving time where applicable. The result shows the local time in the destination zone at the same moment, which is essential for scheduling international calls and meetings.

Can a time calculator handle payroll and work hours?

Yes. A work hours calculator subtracts break times from total shift duration, handles overnight shifts that cross midnight, and totals hours for a week or month. Many tools also multiply hours by an hourly rate to compute gross pay, which saves a separate calculation step.

What is the difference between 12-hour and 24-hour time formats?

The 12-hour clock uses AM and PM to distinguish morning and afternoon times, cycling from 12 to 12 twice a day. The 24-hour clock runs from 00:00 (midnight) to 23:59 without AM or PM. Military and aviation contexts use the 24-hour format because it eliminates ambiguity between morning and evening times.

How do I calculate time in Excel across midnight?

If the end time is earlier than the start time, the period crosses midnight. Use the formula =IF(B2<A2, 1+B2-A2, B2-A2) and format the result as time. Alternatively, include the date alongside the time in both cells and subtract directly — this is the most robust approach for multi-day spans.

What is elapsed time and how is it different from clock time?

Elapsed time is the duration that passes between two events — for example, 3 hours and 45 minutes. Clock time is a specific point on the 24-hour cycle, such as 2:30 PM. An elapsed time calculator measures duration; a clock tells you the current moment. The two concepts serve different purposes and should not be confused.

How do I convert decimal hours to hours and minutes?

Multiply the decimal portion by 60 to get minutes. For example, 2.75 hours equals 2 hours and 45 minutes (0.75 × 60 = 45). To convert back, divide the minutes by 60 and add to the hours. A time to decimal calculator handles both directions instantly and without rounding errors.

In essence, a time calculator is a precision tool for a measurement system that refuses to behave like ordinary numbers. Base-60 arithmetic, midnight rollovers, daylight saving transitions, and time zone offsets all conspire to make even simple duration calculations error-prone when done by hand. Whether you are reconciling a payroll timesheet with a work hours calculator, scheduling a cross-continental call with a time zone converter, converting between 12-hour and 24-hour formats, or simply adding up the total runtime of a project, the tool replaces mental borrowing and carrying with instant, verifiable accuracy. Use the time calculator above, enter your values in the format that matches your source data, and trust the output as a precise measure of elapsed time — not an approximation.