Forum Discussion
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?
=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.
2 Replies
=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!
