Question: how to calculate difference in hours?
Answer: Difference in hours, ignoring minutes and seconds: =HOUR(B2-A2) Difference in minutes, ignoring hours and seconds: =MINUTE(B2-A2) Difference in seconds, ignoring hours and minutes: =SECOND(B2-A2)