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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Countif between Time stamps and have - value 0
Time Sum in Excel 1
Sum Time 7
Convert times to text string 3
Running Sum 0
Calculate the total overlapping time of multiple tasks, excluding non-working times 1
Elapsed time with only 1 column 3
converts military time into standard AM/PM . 8

Top