Excellers,

How may I write two formulas with SUMPRODUCT below?

ID Start Time End Time
13-01294-001 5:00 7:00
13-01294-002 12:00 1:00

After the SUMPRODUCT is calculated, the result should show 3:00 (3 hours).

I know there is a simple way to write this... but I do not know how!

Attached is a sample workbook to play around with.
SampleHelp.xlsx

Many thanks!!