Time as min:sec

[thekruser]

What I have:
tblTraining
-CompletionTimeMin
-CompletionTimeSec



What I am trying to do:
I have to calculate a score based on predetrimined criteria. An employee has to complete a task in a specified amount of time to get 100%.

The problem:
Right now I have the minutes and seconds split into two fields. Calcualtions are based on so many points per whole minute and how many points per second. Points are assesed in 10 second intervals. I think it would make more sense to have one field for time with min:sec, but I am not sure how to go about it programmatically.

For example:
Employee A completes the test in 20 min 9 sec based on a task that whose predetermined cutoff is 20 min. Employee A's score should be 99.

Any help you could give on this subject would be greatly appreciated. Thank you in advance for your time and help. Have a nice day.

[weekend00]

one filed with only seconds is much more simple.
20min 9 sec = 1209 sec

[thekruser]

I agree, but I need to make it as simple as I can for the clerks to enter the time. I can combine the min and sec fields in a query to run the calculation, but I am wondering how to complete the calcultion if I had only one field for time (min:sec).

[weekend00]

if you want min:sec, I prefer it in two fields. it's much easier than put in one field.

but if you want to put in one field in unit of second. the update query is:
update table1 set [seconds]=[min]*60+[sec]

[thekruser]

Ok. Thank you. I agree with havein it in two fields, but I wanted to make sure what I was doing wasn't the "wrong" way to do it.

[weekend00]

whether it is a wrong or right way depends on how will you use the field.

if you only use this field to show on a report or query. min:sec is an good option.
but min:sec is hard to do any calculation.

[thekruser]

That is what I came to figure out, but have noticed that the easy way in Access is usually the wrong way (pertaining to queries) and wanted to make sure.

Thank you for your time and help.