Excel – How to get time difference from cells formatted as dd/mm/yyyy hh:mm in Excel

date timemicrosoft excelworksheet-function

I have two columns of dates and times, formatted as Custom dd/mm/yyyy hh:mm.

A third column is =C3-B3, =D3-D3, =x3-x3, etc.

excel cells

As you can see, it does not tell the difference in days, hours and minutes, as I would like, but shows the difference in a date format, with the days, hours and minutes being correct, but with January 1900 added for some weird reason.

How would I get a result with just the difference in days, hours and minutes?

I originally added a link to an example file HERE, but I noticed that when I open the link in Incognito Mode, to make sure that it was Public, I noticed that it turns the dates into mm/dd/yyyy format, which is really stupid and even more confusing.

Best Answer

enter image description here Write this formula in cell D3 and fill down as necessary.

=INT(C3-B3)&" Days "&HOUR(MOD(C3-B3,1))&" Hour "&MINUTE(MOD(C3-B3,1))&" Minutes"

I hope this helps.

Related Question