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.

Adding and Subtracting Dates and Times Link  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 Sorry, only students may add comments. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

Two New Excel Tips Date Time Differences Link  Sagar Ghosh  6 years ago Please Detail about Date/Time Different Reply from Alex Hedley: The video linked in the article explains all. Sorry, only students may add comments. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

Adding and Subtracting Dates and Times Link  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. Reply from Richard Rost: Read More... Just add A1 and B1 to get the date/time. Then subtract the two resulting cells to get the difference. Sorry, only students may add comments. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

Two New Excel Tips Date Time Differences Link  Lito Tayoan  8 years ago How can compute the number of hours of a flight of diffirent timezones. Sorry, only students may add comments. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.