Question: how to calculate the difference of hours between two dates in google spreadsheet?
Answer: =HOUR(B2-A2) - to return hours only (without minutes and seconds)
=MINUTE(B2-A2) - to return minutes only (without hours and seconds)
=SECOND(B2-A2) - to return seconds only (without hours and minutes)