View Single Post
Old February 15th, 2005, 11:24 PM
Bob Bedell Bob Bedell is offline
Friend of Wrox
Join Date: Jun 2003
Location: , , USA.
Posts: 1,093
Thanks: 1
Thanked 12 Times in 11 Posts

Actually what you're attempting to store here, and what your users are entering, are simple string values, not time values as time values are understood by Access (8-byte floating point numbers).

You would need to write a little string parsing routine to locate the semi-colon in your string (e.g., Instr (1, "2:13", ":")), then parse off the characters strings to the right and left of the semi-colon, and append "mn." and "sec." respectively to the two sub-strings.

If I get some time I'll give it a whirl.