Google Spreadsheet Calculate Date and Time Difference
(by Czar Augusto)
Now, have a look at the following screenshot:
Here in the above sheet,
Cell B1 contains following formula:
Cell B2 contains following value:
Now, put the following formula in Cell B5:
=rounddown(B1-B2) & " days, " & hour(B1-B2) & " hours, " & minute(B1-B2) & " minutes and " & second(B1-B2) & " seconds."
Or use the following formula:
=rounddown(B1-B2) & " days and " & time(hour(B1-B2);minute(B1-B2);second(B1-B2)) & " hours."
I hope the above solution will help you, and if you need more help then please do comment below on this blog itself, I will try to help you out.