OK, I couldn’t stay away…

Thanks Stefan,

The problem I'm having right now is the user Input format not necessarily the calculation part.  If I use a column named 'Time' and set the value to "Time" then it requires the user to enter hh:mm:ss AND am or pm, in other word, a clock time not an elapsed time.  This is not intuitive for an end user.  I want them to be able to enter say 23:15.33 (no am/pm and no hours if not required) for 23 min, 15 sec and 33/100 of a sec.  I have tried using text fields then converting it to string then time, example: convert([Hours] + ':' + [Min] + ':' + [Sec] + ' am', 'System.String')) but I cant get it to recognize the column for "ticks" calculations.

So, how can I enter say 1:23.55 or 2:21:33.9 (no am/pm) in a text, time, what-ever field and covert it to a format I can perform "ticks" type calculations?

Any suggestion? Thanks,

-e

OK, so I have tried another approach and I think I'm getting closer.  

User enters [Hours] [Minutes] and [Seconds] separately and then I convert it.  Works great if ALL the fields are fill in, even with a '0' (zero) BUT doesn't work if ANY of the fields are left blank (un-touched)... then I cant perform any calculations.  I tried setting the field to '0' (zero) with IsNull but no luck.  Also, setting the Default Value to 0 (zero) does nothing, it doesn't take.

Any Suggestions??