Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Working with times as conditions in formulas
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Working with times as conditions in formulas
If my interpretation of your question is correct then TimeValue(time2.text)
should return a proper time value. -- Regards, OssieMac "NDBC" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Working with times as conditions in formulas
OssieMac you are a champion. You deserve gold status. Thanks heaps. Worked a
treat. "OssieMac" wrote: If my interpretation of your question is correct then TimeValue(time2.text) should return a proper time value. -- Regards, OssieMac "NDBC" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating Non-working Dates and Times | Excel Discussion (Misc queries) | |||
Working With Times / Milliseconds | Excel Worksheet Functions | |||
Working with times | Excel Discussion (Misc queries) | |||
How:iserror vlookup & count no. times value shows with conditions | Excel Worksheet Functions | |||
how do i count how many people are working between two times in e | Excel Worksheet Functions |