Just trying to get my head around this..
I have a time in string format as "2.40" and want to add this to a Date Field formatted "mm:ss". (If that's right - should "ss" be "n")
Code:
Function Dur(f as string) As Date
'f= "2.40"
Dur = "00." & Minute("00." & f) & "." & Second("00." & f)
End Function
When i print the result I see 12:02:40 AM which is not really what's wanted.
If I put 12:02:40 AM into my date field will it lose the 12 and AM ?
I will try and see. Or and I doing this all wrong and a better way exists?