Excel 2010-2019 Excel 2007 Excel 2003 Tips & Tricks Excel Forum Course Index CIG Excel Book

 Home   News   Courses   TechHelp   Templates   Forums   Help   Order   Contact   Logon More... What's New? Tips & Tricks Access Index Access Tips Excel Index Excel Tips Waiting List

Two New Excel Tips: Date/Time Differences
By Richard Rost     9/18/2012 3:12:27 PM

It's been a while since I've posted a new Excel tip, so here are two of them.

Calculating the difference between two DATES in Excel

Calculating the difference between two TIMES in Excel

I also gave the Excel Tips and Access Tips sections a much-needed face lift.

Dharmendra
2/27/2016
i can't calculate of difference
4:30:00-19:30:00
its shows 15 hours
But real is
9 hours acc to watch
Two New Excel Tips Date Time Differences Link
Sagar Ghosh
7/21/2015

The video linked in the article explains all.
Sankalp G
9/5/2013
I need to subtract time and date in differnt cells, for example
A1= Date
B1= Time
A2=Date
B2=Time
Now, i require to time duration between A1 B1 and A2 B2.

Two New Excel Tips Date Time Differences Link
Lito Tayoan
2/1/2013
How can compute the number of hours of a flight of diffirent timezones.

Post a New Comment or Question
 Only students may post right now. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

 You may want to read these articles from the 599CD News:
 8/14/2020 Excel XLOOKUP Function 8/14/2020 Excel Worksheet Change VBA 8/14/2020 Excel TechHelp 7/27/2020 How to Get Microsoft Excel for Free 5/25/2020 Excel Expert 11 5/20/2020 Excel My Name is Richard 5/20/2020 Excel Expert Level 11 5/20/2020 Excel Expert 11 Outline 5/4/2014 Microsoft Access Expert 20 3/5/2013 Excel Tip: Price Markups

 Learn  Access - index Excel - index Word - index Windows - index PowerPoint - index Photoshop - index Visual Basic - index ASP - index Seminars More... Customers  Account Login Online Theater Downloads Lost Password Free Upgrades Insider Circle Student Databases Change Email Info  Latest News New Releases User Forums Topic Glossary Tips & Tricks Articles Search The Site Waiting List Production Schedule Collapse Menus Help  Live Chat Customer Support WalkThru Tutorials Troubleshooting FAQs TechHelp Consulting Services About  Background Testimonials Jobs Affiliate Program Richard Rost Free Lessons Mailing List Order  Video Tutorials Handbooks MYOLP Memberships Learning Connection Idiot's Guide to Excel Volume Discounts Payment Info Shipping Terms of Sale Contact  Live Chat General Info Support Policy Contact Form Email Richard Mailing Address Phone Number Fax Number Course Survey
Keywords: excel tips difference between two dates difference between two times  PermaLink