Re: Time format hh:mm:ss.000
Actually my requirement: I have *.csv file which has device power quality data, every sec 25 lines will be logged into *.csv file(it will be in millisecond). To extract the correct report i need to locate the specific time ("1:38:30") then i select range of cells for custom report file. Problem i faced is "1:38:29.533" is consider as "1:38:30" while find option using macro. so using this formula to locate row value and then extracting the range
Quote from venkateswaran;642235
Thanks all for ur effort. got the solution by using below formula.