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

 Home   Courses   Seminars   Templates   Help   TechHelp   Forums   Contact   Join   Order   Logon More... What's New? Popular Links ------------ Access Courses Access Index Access TechHelp Access Forum ------------ Excel Courses Excel Index ------------ Code Vault Testimonials

Two New Excel Tips: Date/Time Differences
By Richard Rost     9 years ago

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
5 years ago
i can't calculate of difference
4:30:00-19:30:00
its shows 15 hours
But real is
9 hours acc to watch
Sagar Ghosh
6 years ago

The video linked in the article explains all.
Sankalp G
8 years ago
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.

Lito Tayoan
8 years ago
How can compute the number of hours of a flight of diffirent timezones.

Start a NEW Conversation
 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:
 6/23/2021 Import Data 5/14/2021 Quick Queries #4 4/4/2021 Text to Columns 3/15/2021 VLOOKUP in Access 2/17/2021 Old Excel 2003 Outlines 2/17/2021 Excel Expert Outlines 2/17/2021 Excel Beginner Outlines 2/4/2021 Free Beginner Courses 12/26/2020 Import New, Changed Records 12/13/2020 Duplicates Conditional Formatting

 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 Memberships Student Databases Change Email Info  Latest News New Releases User Forums Topic Glossary Tips & Tricks Search The Site Code Vault Collapse Menus Help  Customer Support Web Site Tour FAQs TechHelp Consulting Services About  Background Testimonials Jobs Affiliate Program Richard Rost Free Lessons Mailing List Order  Video Tutorials Handbooks Memberships Learning Connection Idiot's Guide to Excel Volume Discounts Payment Info Shipping Terms of Sale Contact  Contact Info Support Policy Email Richard Mailing Address Phone Number Fax Number Course Survey
Keywords: excel tips difference between two dates difference between two times  PermaLink