Time calculations

[jimandann]

Is there a way I can enter a one to three digit number, have it appear as a three digit number, but have it stored in short time (nn:ss). For instance, in a form or table, I want to enter the number 135 and have it displayed as 135. However, I want the number stored as 02:15, meaning that the 135 is one hundred and thirty five seconds. This then gets stored as 2 minutes 15 seconds. I plan to use the stored 02:15 in a later time calculation.

Thanks.

[RuralGuy]

I find that this link helps to understand the DateTime DataType a little better: http://support.microsoft.com/default.aspx/kb/q130514/

[thhui]

Define a function to hold the min:sec variables

Function time_M(a)
mm = a \ 60
ss = a Mod 60
time_M = TimeSerial(0, mm, ss)
End Function

Then you can use a, or time_M(a) freely.