I'm trying to extract only hh:mm:ss from the mm/dd/yyyy hh:mm:ss.000 format. reason behind this is, i need to search exact hh:mm:ss, when it is found i will locate that row as starting and copy range of records.For that what i'm doing is
Ex.
A1 12/28/2012 09:10:10.123 B1 =Left(Mod(A1,1),find(".",Mod(A1,1))-1)
A2 12/28/2012 09:10:10.678 B2 =Left(Mod(A2,1),find(".",Mod(A2,1))-1)
A3 12/28/2012 09:10:11.108 B2 =Left(Mod(A2,1),find(".",Mod(A3,1))-1)
getting error 0 value but expected value is 09:10:10, 09:10:10, 09:10:11
Appreciate ur great help
Regards,
venkates k