We help IT Professionals succeed at work.

New podcast episode! Our very own Community Manager, Rob Jurd, gives his insight on the value of an online community. Listen Now!

x

subtract date and time display how many minutes difference

KnutsonBM
KnutsonBM asked
on
510 Views
Last Modified: 2012-05-10
How can i subtract two dates and times and display the difference in Minutes?

-Brandon
Comment
Watch Question

CERTIFIED EXPERT
Top Expert 2008
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
CERTIFIED EXPERT
Most Valuable Expert 2013

Commented:
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

Author

Commented:
exactly what i was looking for, thanks!
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.