I am building an application that will track time. The issue comes into play that a user may want their time entered in different formats such as they accomplished 1.5 hours of training. This could be logged as 1.5, 1.50, 1.500, 01:30, etc.

What is the best way to STORE this value so the accuracy and format is preserved? What type of Data Field in Access or SQL Server?