SOLVED

# calculate duration time

Copper Contributor

# calculate duration time

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 Replies
best response confirmed by Vincent_1978 (Copper Contributor)
Solution

# Re: calculate duration time

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

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

Sample in file.

# Re: calculate duration time

@NikolinoDE  Thank you, this works fine for me!

1 best response

Accepted Solutions
best response confirmed by Vincent_1978 (Copper Contributor)
Solution

# Re: calculate duration time

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

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

Sample in file.