To calculate time duration in minutes in Excel, subtract the start date-time from the end date-time and multiply the result by 1,440, using =ROUND((B2-A2)*1440,0) when you want a whole-minute answer. The factor 1,440 is required because Excel represents date-time values as fractions of a day, and one full day contains 1,440 minutes. This worksheet formula is useful when the values already sit in cells and should update with the source data. When you need the result immediately without building a sheet, the Time Duration Calculator provides the same elapsed-time task in a simpler interface: enter two date-times and read the human-friendly breakdown along with total days, hours, minutes and seconds. Use full dates as well as clock times whenever the interval may cross midnight, because the date identifies which day the clock reading belongs to. In Excel, confirm that the source cells are recognized as date-times rather than plain text, put the formula in a separate cell, and apply a Number format to display the result as minutes instead of a clock-style duration.
Why Excel’s 1,440-minute conversion works
Excel stores each date-time as a serial value: the date portion counts days, while the time portion is a fraction of one day. When B2 contains a later date-time than A2, subtracting A2 from B2 therefore produces the elapsed number of days. Multiplying that result by 1,440 converts the span into minutes without requiring you to separate days, hours and minutes into separate calculations.
Keep the parentheses around the subtraction. Without them, a formula such as =B2-A2*1440 applies the multiplication only to A2 before subtracting it from B2, which produces a misleading result. The raw formula =(B2-A2)*1440 keeps the date-time difference intact and can also produce decimal minutes when the inputs include seconds.
Calculate time duration in minutes in Excel
Use this worksheet sequence when the start and end values need to remain connected to your records.
- Enter the start date and time in A2. Use Excel’s date/time picker or type a complete value that your regional settings recognize. Include the date even when both readings occur on the same day.
- Enter the end date and time in B2. Keep both fields on the same date-time basis. For an overnight span, the end date tells Excel that the clock reading belongs to the next day.
- Calculate total elapsed minutes in C2. Enter =(B2-A2)*1440. This returns decimal minutes, which is useful when seconds matter.
- Round only if a whole-minute answer is required. Replace the formula with =ROUND((B2-A2)*1440,0). The final zero specifies the number of decimal places, not an additional unit.
- Format the result as a number. Choose the Number format and set the visible decimal places. A clock-style Time format can obscure the fact that the cell contains a raw minute total.
- Copy the formula down for additional records. Adjust the row references as needed. If the end may fall before the start and only the magnitude matters, use =ABS((B2-A2)*1440); keep the signed version when direction matters.
Keep the start and end values in separate cells rather than embedding them in the formula. That keeps the calculation easy to audit, adjust and copy.
Check one full calculation
In one example, A2 contains January 1, 2025 at 9:00 AM and B2 contains January 2, 2025 at 10:30 AM. The elapsed span is 25 hours and 30 minutes, so the Excel calculation is (January 2, 2025 10:30 AM − January 1, 2025 9:00 AM) × 1,440 = 1,530 minutes. Entering =ROUND((B2-A2)*1440,0) returns 1,530. The end date is essential because it identifies the full 25-hour, 30-minute span; clock values alone do not show which calendar day comes next.
Get live totals with the Time Duration Calculator
This calculator gives you the total in minutes alongside days, hours and seconds, without embedding a formula in a worksheet.
- Pick or type the start date and time in the first field.
- Pick or type the end date and time in the second field.
- Read the duration breakdown and the total days, hours, minutes and seconds, which update instantly as you edit either field.
There is no submit button and nothing to configure. Once both fields contain valid values, the result appears automatically. The readable breakdown omits empty units, while the running totals provide each unit directly. This makes the calculator useful when you want both a human-friendly summary and a precise minute total, then change one input to test a different interval.
The calculator treats both entries as readings from the same plain wall clock. It performs no time-zone conversion and makes no daylight-saving adjustment, so its result is a straightforward elapsed span. If the end is earlier than the start, it shows the absolute duration and clearly notes that the end comes first. Identical inputs produce a zero-second duration rather than a blank result.
Calculation happens entirely in the browser with plain JavaScript. Dates, times and other entered information are not uploaded, logged or sent to a server. No account is required, and the page can continue working without a network connection once it has loaded.
Choose the method that matches the result you need
The two approaches answer the same elapsed-time question but fit different working environments.
| Need | Excel worksheet | Time Duration Calculator |
|---|---|---|
| Repeated records | Copy a formula down and let cell references track each row. | Enter a new pair and watch the result refresh as either value changes. |
| Main output | Total minutes, with decimals or rounded to whole minutes. | Readable breakdown plus running totals for days, hours, minutes and seconds. |
| Reversed inputs | Raw subtraction is negative; ABS can return only the magnitude. | Shows the absolute span and labels that the end is before the start. |
| Clock basis | Uses the date-time values stored in the worksheet. | Treats both entries as one plain wall clock, with no time-zone or daylight-saving adjustment. |
| Processing | Runs as a worksheet formula. | Runs in the browser with plain JavaScript; entered values are not uploaded. |
Use the Excel method when the duration must remain attached to a growing list of records. Use the calculator for a one-off check, a boundary case or rapid comparison of several date-time pairs. For a longer walkthrough of spreadsheet setup, see Calculate Time Duration in an Excel Sheet. The formula stays in the workbook, while the calculator supplies immediate reference totals.
Avoid misleading minute totals
Most errors come from input formatting or from applying the 1,440 factor to the wrong part of the formula.
- Do not leave out the date for an overnight span. Two clock readings alone do not tell Excel which calendar day comes next.
- Keep source values as date-times. If a cell contains text, Excel may not subtract it as a numeric date-time, so re-enter it with the date/time picker.
- Do not format the minute total as a clock. Select Number or General so the result communicates its actual scale.
- Decide when rounding belongs. Keep the raw result for precision, and add a rounded value only when a whole-minute figure is the required output.
- Check the order of the two fields. A negative Excel difference means the end is earlier; ABS removes the sign but also removes that directional information.
The calculator has a different, explicit rule for a reversed pair: it retains the useful magnitude and adds a warning-style note. It is intentionally a raw elapsed-time tool rather than a time-zone converter, so do not use its plain-clock result as a daylight-saving-adjusted or cross-zone duration. If the task is to count working days instead of every elapsed minute, use a business-day method such as How to Calculate Business Days Between Dates in Excel.
Build a repeatable time-record workflow
For recurring records, standardize the sheet before adding formulas. Label the start and end columns, enter complete date-times in a consistent format, and reserve one column for the raw minute formula. If reviewers also need whole minutes, place =ROUND((B2-A2)*1440,0) in the next column rather than replacing the precise value. A Number format on both columns makes the units clear and reduces ambiguity during review.
For a one-off measurement, the calculator takes only two inputs. Enter the pair, read the minute total, adjust either field, and check the refreshed breakdown. That approach suits shifts, sessions, trips, cooking, workouts, study blocks, project phases and contract periods. In short, use the Excel formula for worksheet-native calculations, and use the Time Duration Calculator when you want an immediate, exact total across multiple units.