Tracking Time

[neal007]

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?

[Hole-In-One]

Could you just make them sign in and sign out for training? That way you can just get the difference of the two, then just format it and enter it into your database the way you want. Give the user a little less control and tkae away some of the chance for error.


Other wise you could just use the vb6 masked edit textbox setup like this maybe ##:##?

[neal007]

No, they aren't necessarily training on a computer. They could be off on a road trip and have to log their time away, etc.

It's not a formatting question at this point, it's a storage question. How is the best way to STORE this data so it can be formatted in any of the formats listed (real time, decimal, etc.)?