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
 

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
Content 2
if statement 2
15 minutes early 5
Formula to another forumula? 10
time calculations 2

Back
Top