Calculate the time elapsed in days, hours and minutes between two date and times entered into Excel.

Excel stores date and times as a number with decimals. Because of this we cannot simply subtract the two values.

This video tutorial uses a combination of functions to calculate the time elapsed and display it in an easy to understand format. The INT and MOD functions play important roles in making this happen.

Liked the Video? Subscribe: http://bit.ly/computergaga

Find more great free tutorials at;
https://www.computergaga.com

*** Online Excel Courses ***

The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel
Excel VBA for Beginners ► http://bit.ly/37XSKfZ
Advanced Excel Tricks ► https://bit.ly/3CGCm3M
Excel Formulas Made Easy ► http://bit.ly/2ujtOAN
Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2Siivkm

Connect with us!

LinkedIn ► https://www.linkedin.com/company/18737946/
Instagram ► https://www.instagram.com/computergaga1/
Twitter ► http://www.twitter.com/computergaga1

Please take the opportunity to connect and share this video with your friends and family if you find it useful.