My objective is to make a log in/log-out system that will compute the total number of hours of an employee…I used vb 6.0 as my front-end to ms sql 2000 as the back-end. The time will be saved on the database and the corresponding date (e.g. 2008-11-25 10:00:00 AM) since the time and date cannot be recorded in separate manner because of the data type datetime of the ms sql. My problem is how to compute and retrieve the time alone from the database and the date will be not included? Kindly share your ideas please. Thanks in advance.