Sum Time with text values in column

[hotherps]

I have two columns that I have to subtract from eachother to get the sum
of hours. However the column also contains some text values, when I try
to use any formula I'm getting ##########. So when I try to sum The
results, it will not work.
I also have to subtract 30 minutes from each total.

I tried ISERR

Looks lIke this
A1 B1 C1
8:00am 5:00pm 9:00
8:00am 5:00pm 9:00
Vacation #########
8:00am 5:00pm 9:00
Sick #########

 

[Frank Kabel]

Hi
post your formula

 

[Guest]

Why don't you put a if statement before the sum, so in c2 =
if(b2="","",b2-a2-0.30) or similar, including your time statement.

HTH
Tim.