Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
How to calculate minutes between two timestamps in Excel and Google Sheets
Excel & Google Sheets
=ROUND((B2-A2)*1440,0)✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| Start Time | End Time | Minutes Difference |
| 9:00 AM | 10:30 AM | |
| 12:45 PM | 1:15 PM | |
| 3:30 PM | 4:00 PM |
=ROUND((B2-A2)*1440,0)→90
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
Step by step
- 1Enter your start timestamp in cell A2 and end timestamp in cell B2.
- 2In cell C2, enter the formula to calculate the difference in minutes.
- 3Press Enter to see the result.
Tips
- Ensure timestamps are in a date-time format recognized by Excel or Google Sheets.
- The formula multiplies the time difference by 1440 because there are 1440 minutes in a day.
- Use the ROUND function to avoid fractional minutes if whole numbers are preferred.
Working on a sheet you inherited? Run the Auditor on the whole file first — it flags every #REF!, #N/A, broken column pattern, and inconsistent formula in seconds, free, no signup.
Frequently asked
What if my timestamps include seconds?
The formula will still work as it calculates the full time difference.
Can I use this formula with dates only?
Yes, but it will return 0 unless there's a time component.
How do I handle negative time differences?
Check your timestamps to ensure the end time is later than the start time.