Formula for differences in dates with times

[Stef9910]

Hello awesome forum,

I know this question is probably basic, but cannot work it out to give me the correct amount of days, hours and minutes.

I am trying to find the difference between the following,

8/11/2022 8:55:00 PM and 15/12/2022 2:02:00 PM

Manually I know the answer is 36 days 17 hours and 7 minutes

Please could you help me a formula?

 

[Alex Blakenburg]

Give this a try:

Book2
	A	B	C
1	From	To	Result
2	8/11/2022 20:55	15/12/2022 14:02	36 Days 17 Hrs 7 Mins
Sheet1

Cell Formulas
Range	Formula
C2	C2	=INT(B2-A2) & " Days " & HOUR(B2-A2) & " Hrs " & MINUTE(B2-A2) & " Mins"

 

[Stef9910]

Thank you so much Alex,
Just what I needed, worked brilliantly,
Thank you
Stefan

 

[Alex Blakenburg]

You're welcome. Glad I could help.