Skip to main content

How to Calculate the Difference in Minutes Between Two Times in Batch Script

Measuring the time elapsed between two events is essential for performance monitoring, SLA compliance, and execution benchmarking. While comparing raw time strings is difficult, converting both timestamps to a single unit, Total Minutes since midnight, makes the subtraction trivial.

In this guide, we will demonstrate how to calculate the difference in minutes between two given times.

The Strategy: Convert to Minutes, Then Subtract​

  1. Parse Time A into Hours and Minutes.
  2. Convert to "Total Minutes": TotalA = (Hours * 60) + Minutes.
  3. Do the same for Time B.
  4. The difference is |TotalB - TotalA|.

Implementation Script​

@echo off
setlocal enabledelayedexpansion

:: 1. Input two times (24-hour format HH:MM)
set "timeA=09:15"
set "timeB=14:42"

:: 2. Parse Time A
for /f "tokens=1,2 delims=:" %%A in ("!timeA!") do (
    set /a "hA=1%%A - 100"
    set /a "mA=1%%B - 100"
)

:: 3. Parse Time B
for /f "tokens=1,2 delims=:" %%A in ("!timeB!") do (
    set /a "hB=1%%A - 100"
    set /a "mB=1%%B - 100"
)

:: 4. Convert to Total Minutes
set /a "totalA=(hA * 60) + mA"
set /a "totalB=(hB * 60) + mB"

:: 5. Calculate Difference
set /a "diff=totalB - totalA"

:: Handle midnight crossing
if !diff! LSS 0 set /a "diff+=1440"

:: 6. Convert difference back to Hours:Minutes
set /a "diffH=diff / 60"
set /a "diffM=diff %% 60"

echo.
echo ==========================================
echo TIME A:      !timeA!
echo TIME B:      !timeB!
echo DIFFERENCE:  !diff! minutes (!diffH!h !diffM!m)
echo ==========================================
pause
Midnight Crossing

If Time A is 23:30 and Time B is 01:15, the raw subtraction produces a negative value (75 - 1410 = -1335). Adding 1440 (the total minutes in a 24-hour day) corrects this to 105 minutes, which is the actual elapsed time across midnight. This assumes Time B is always after Time A chronologically.

Interactive Version​

To accept user input instead of hardcoded values:

@echo off
setlocal enabledelayedexpansion

:: Prompt for input
set /p "timeA=Enter start time (HH:MM, 24-hour): "
set /p "timeB=Enter end time   (HH:MM, 24-hour): "

:: Parse Time A
for /f "tokens=1,2 delims=:" %%A in ("!timeA!") do (
    set /a "hA=1%%A - 100"
    set /a "mA=1%%B - 100"
)

:: Parse Time B
for /f "tokens=1,2 delims=:" %%A in ("!timeB!") do (
    set /a "hB=1%%A - 100"
    set /a "mB=1%%B - 100"
)

:: Validate ranges
if !hA! GTR 23 ( echo [ERROR] Start hour out of range. & pause & exit /b )
if !hB! GTR 23 ( echo [ERROR] End hour out of range. & pause & exit /b )
if !mA! GTR 59 ( echo [ERROR] Start minutes out of range. & pause & exit /b )
if !mB! GTR 59 ( echo [ERROR] End minutes out of range. & pause & exit /b )

:: Convert to Total Minutes
set /a "totalA=(hA * 60) + mA"
set /a "totalB=(hB * 60) + mB"

:: Calculate Difference (with midnight crossing support)
set /a "diff=totalB - totalA"
if !diff! LSS 0 set /a "diff+=1440"

:: Convert difference back to Hours:Minutes
set /a "diffH=diff / 60"
set /a "diffM=diff %% 60"

echo.
echo ==========================================
echo START:       !timeA!
echo END:         !timeB!
echo DIFFERENCE:  !diff! minutes (!diffH!h !diffM!m)
echo ==========================================
pause

Why Calculate Time Differences?​

  1. Performance Benchmarking: Measuring how long a script (or a portion of it) took to execute.
  2. SLA Monitoring: Checking if a service responded within the 15-minute SLA window.
  3. Shift Management: Calculating the number of working hours between a clock-in and clock-out time.

Important Considerations​

Leading Zero Octal Trap

Batch treats numbers with leading zeros as octal. The hour and minute values 08 and 09 are invalid octal numbers and cause errors with set /a. The trick set /a "hA=1%%A - 100" prepends a 1 to create a valid decimal number (e.g., 108), then subtracts 100 to get the correct value (8).

Second-Level Precision

If you need second-level precision, extend the formula to convert to total seconds instead of minutes:

set /a "totalA=(hA * 3600) + (mA * 60) + sA"
set /a "totalB=(hB * 3600) + (mB * 60) + sB"
set /a "diff=totalB - totalA"
if !diff! LSS 0 set /a "diff+=86400"

Use 86400 (seconds in a day) instead of 1440 for the midnight crossing correction.

Using %TIME% for Benchmarking

Capture %TIME% at the start and end of a code block to measure execution duration:

set "startTime=%TIME%"
:: ... your code block ...
set "endTime=%TIME%"

Parse both values, convert to total seconds (or centiseconds for %TIME%'s precision), and subtract for a precise execution timer.

Conclusion​

Calculating the time difference in minutes is a fundamental "metrics" capability for any system administration script. By converting human-readable timestamps into flat integer values, you enable effortless mathematical comparison. This technique is the backbone of performance monitoring, SLA compliance checking, and execution timing in any Windows command-line automation workflow.

Table of Contents