calculate duration time

[Vincent_1978]

Hi everybody,

As you can see in attachment, i have data extracted from a Labo Lims system , with 2 columns (Login Date and Date reviewed)  The difficult thing for me is that every cell contains a date and a time notation.

I want to calculate the time difference between the column date reviewed and login date.  Please note that between the two columns, there can be a difference of more than one day.

Is this something that is possible in excel?

[#2 · Accepted solution]

@Vincent_1978 

=TEXT(B2 - A2, "d hh:mm")

This way you can calculate the time difference in hours, minutes & Days.

Sample in file.

Hope this will help you.

[#3]

@NikolinoDE  Thank you, this works fine for me!