Working with times as conditions in formulas

N

NDBC

I have now located the times. Thanks for your help with the last post. This
line is giving me a type mismatch error. When I check the values by holding
my mouse over them in debugger it has Time2.text in h:mm:ss format and
lastlap and Range(c14) as 0.000567 (time in non time format). Is this the
cause of the error and if so what is the asiest way to put time2.text into
number format.

If Time2.Text - lastlap > 1.4 * Range("c" & riderCell.Row) Or Time2.Text -
lastlap < 0.4 * Range("c" & riderCell.Row) Then

Thanks
 
O

OssieMac

If my interpretation of your question is correct then TimeValue(time2.text)
should return a proper time value.
 
N

NDBC

OssieMac you are a champion. You deserve gold status. Thanks heaps. Worked a
treat.
 

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

trouble with subtracting elapsed times 17
writing coloured text with formulas 2
Using variable names in a loop 3
I want to use the MATCH function with the AVERAGE function but I . 2
Time Aggregate in [h]:mm:ss format in a loop & julian date 3
Custom functions calculating time arguments Help Desperate 12
I need help with this program written in Visual Basic for Excel 2007. 4
Calculations on Times Formatted as Text 5

Top