>I have time data stored as string type, how can I convert them back to time.
>Also, how to compare them with the current time ? Thanks
CDate() works for that. You can use IsDate() to check if the string can be converted to a Date format. Sample:
Debug.Print CDate("4:30:55 PM")
HTH