Hello,
I am having issues with comparing time values (stored as text) when the numbers being compared are less than 10 and greater than 10. For example, 10 minutes (10:00.00) is registering as less time than 9 minutes (9:00.00). Is there an easy way around this so the comparison is correct. I've got a large list of times, so I have to keep it stored as text to ensure the data remains unaltered by excel and I also concatenate these times in formulas elsewhere in my workbook so I can't do any custom formating.
A1: 10:10.25
B1: 9:59.02
Formula:Please Login or Register to view this content.
It works properly when formatted as General or Custom (m:ss.01), but the problem is when I import the data through my macro, columns A and B do not just contain times (other data includes stuff like 24.25, 11.24cm, "-").
Thanks in advance for any help!
RJ
Bookmarks