Ignore Text when calculating time
 

I am trying to get a time sheet (schedule) to work that will calculate mil
time.
I am able to calculate the time nicely but, is there a way to ignore text
that may end up in a cell. Such as SICK or HOL. The string I am currently
use to add up time entered in mil time and convert to hours worked follows.
=(B5C5)+-C5-B5
I simply need a function that will ignore text entered.
Is this making sense:)
Thanks in advance Dale

Ignore Text when calculating time
 

So you are only checking 2 cells? If so

=IF(COUNT(B5:C5)=2,(B5C5)+C5-B5,"")

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"DaleP1" wrote in message
...
I am trying to get a time sheet (schedule) to work that will calculate mil
time.
I am able to calculate the time nicely but, is there a way to ignore text
that may end up in a cell. Such as SICK or HOL. The string I am currently
use to add up time entered in mil time and convert to hours worked
follows.
=(B5C5)+-C5-B5
I simply need a function that will ignore text entered.
Is this making sense:)
Thanks in advance Dale