FG

How to get time difference as minutes in Excel?

Fresh3 days ago
Mar 15, 2026156271 views
Confidence Score0%
0%

Problem

I have time values in two cells in an Excel sheet and I need the difference of the times in minutes. The cells in the Excel are like below: A is the start time B is the end time C is the time difference (B1-A1) which is displayed in hh:mm:ss format A and B cols are formatted as custom hh:mm and cel…

Error Output

A        B        C
1  6:38     8:23     1:45:00

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: How to get time difference as minutes in Excel?

Low Risk

Just set the cell to be shown in numerical format and it will show a decimal number. The integer part corresponds to the date value (i.e. the day) and the decimal part to the time of the day. If you multiply the numerical value of 1:45 (which is 0,0…

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment