Forum Discussion
Solved
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...
=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.
=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.
NikolinoDE Thank you, this works fine for me!