Question: how to calculate the difference of date and time in excel?
Answer: Calculate hours between two times: =TEXT(B2-A2, "h")
Return hours and minutes between 2 times: =TEXT(B2-A2, "h:mm")
Return hours, minutes and seconds between 2 times: =TEXT(B2-A2, "h:mm:ss")