Ignore Text when calculating time

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

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

Limited elapsed time study 1
Excel - Sliding decreasing scale (payroll tax calc) 2
Contents 1
if statement 2
Content 2
15 minutes early 5
time calculations 2
Formula to another forumula? 10

Back
Top