Solved

# How do you calculate the difference between two time fields in MS Excel to a value that is in minutes +/-

Posted on 2011-03-15
212 Views
Hello,
I have two fields (a1 and a2) time format and I need to calculate the difference in the times to a +/- values in minutes (a3 value)

e.g.
a1 09:03
a2 09:07
a3 -3.75 (obviously the seconds field factored in here)
0
Question by:groovymonkey
1 Comment

LVL 85

Accepted Solution

Rory Archibald earned 500 total points
ID: 35138703
=(A1-A2)*24*60

for example.
0

## Featured Post

### Suggested Solutions

Drop Down List with Unique/Distinct Values (enhancing the Combo-Box with a few steps and a little code) David miller (dlmille) Intro Have you ever created a data validation list from a database field or spreadsheet column (e.g., Zip Codes or Co…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.