Excel Formula for Time Elapsed in Days, Hours and Minutes

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.

Find more great free tutorials at;

*** Online Excel Courses ***

Connect with us!

[tonyhaber]

This is the best video I have watched for Time calculations in Days & Hours. Thanks a lot.

[sandeepjaiswal]

Sir your education is like a burning lamp. Who shows the right path. We are very happy with you.

[Junecode]

This video, helped me solve my problem. Been looking for ages you have no idea.

[dhavalmistry]

Respected sir,
I m Dhaval from india. Finding this kind of formula. This is a wonderful. Just complete solution. Love know more & more. Thank you very much And respecte. Manaskara.

[Kitana]

Good Job Explaining. Finally got it after adjusting the cell formatting!

[丅-ry]

Thanks alot for the teaching sir... It's very helpful

[nawazshaikh]

@Computergaga Thanks for sharing this. what will be the formula if I want to exclude the weekend? Please help..

[leannNarcher]

is it possible to incorporate =IF(A2<B2, B2-A2, A2-B2) into this formula? I need to calculate the difference between administered (column A) and documented (column B) time and the dates/times might be flopped and I cannot get your formula to work when the date in column A is after the date in column B.

[erimwolf]

Thanks you for your very informative video! But I do have a question, how would you add all of your differences together afterwards?

[akhmadmingboev]

I never comment on videos but this was just great and helped me resolve my issue. Thanks 🙏

[sizwemchunu]

Thank you for this Tutorial really helpful. I don't want to include hours after shift (22:00 - 07:00). how do I factor the 9 hours out?

[cixmogarcia]

=INT(B2-A2)&" Days"&Hour(MOD(B2-A2, 1))&" Hours "&MINUTE(MOD(B2-A2, 1))&" minutes"

[sekarukl]

Thanks for detailed explanation can you please help to How to calculate average of the difference data generated?

[tangocharlee]

Very Informative and Easy to Understand

[carlosalfonso]

Very important & useful lesson once again, thank you so much!

[muhammadrizwan]

HI, is it possible to calculate the next date and time with counting 8 hrs per day.

[hammadarain]

Good job done you Sir, too much helpful you video

[wawaramli]

How to use the same formula and avoid the holidays, because i am planning to calculate IRT and ORT using excel in my CM project. Please advise and thank you in advanced sir

[dianagoncalves]

hi, How to sum up days, hours and minutes?

[mickqwerty]

Hi, Great video....is there an easy way to show days hrs and mins from the calculation in separate cells?