Solved

subtract date and time display how many minutes difference

Posted on 2010-09-15
3
490 Views
Last Modified: 2012-05-10
How can i subtract two dates and times and display the difference in Minutes?

-Brandon
0
Comment
Question by:KnutsonBM
3 Comments
 
LVL 81

Accepted Solution

by:
zorvek (Kevin Jones) earned 500 total points
ID: 33685352
Total minutes between two date/time values:

   =(B1-A1)*1440

Kevin
0
 
LVL 50

Expert Comment

by:barry houdini
ID: 33685354
If you have a date/time in A2 and a later one in B2 just subtract, i.e.
=B2-A2
You can now use formatting to display the difference as required, e.g. custom format as [h]:mm to show the difference in hours and minutes, so 2 ½ hours will display as 2:30. If you want to see just minutes, i.e. 150 then custom format as [m]
regards, barry
0
 
LVL 6

Author Closing Comment

by:KnutsonBM
ID: 33685368
exactly what i was looking for, thanks!
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
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 simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now