Ignore Text when calculating time

G

Guest

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.
=(B5>C5)+-C5-B5
I simply need a function that will ignore text entered.
Is this making sense:)
Thanks in advance Dale
 
P

Peo Sjoblom

So you are only checking 2 cells? If so

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

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon
 

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

Ignore text in timecard calculation 1
Figuring total # of hours between multiple times 5
Excel Formula, text & number in cell 1
Time calculations for Scheduled Time vs. Actual Time Worked 1
Displaying Time In Decimal Formats 4
calculating hours into date format 1
Time calculations for Scheduled vs Actual Employee Time and Wages 4
Time calculations for Scheduled vs Actual Employee Time and Wages 2

Top