Notice all three criteria use mixed references to lock rows and columns as needed to allow copying.

Excel formula: Sum race time splits

Excel formula: Calculate hours between two times

Excel formula: Get work hours between dates

Excel SUMIFS function