Question: how to calculate duration in excel from time?
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")