Sum Time with text values in column

H

hotherps

That's the problem nothing I tried worked, I tried SUMPRODUCT, IF, an
this

=SUMIF(K5:L298,"if(L5-K5>0")

Start-------End
Vacation Vacation
MILITARY MILITARY
6:30 PM 5:00 AM <<<Subtract these and sum for the whole colunm
LEAD LEAD
Off Off
Off Off
8:00 AM 6:30 PM
8:00 AM 6:30 PM
6:30 AM 3:00 PM
6:30 PM 5:00 A
 
Top