Question: how to calculate hours on google sheets?
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)