Minute Calculation

[yakdogs]

I have a csv file that I am importing and it has a field that I must calculate the amount of minutes, and seconds on. The field in the csv file is set up as 00:00:00.

I am importing the field as:

.Fields("Call_Duration&quot = IIf(Len(Tokens(1)) = 0, "00:00:00", Tokens(1))

I have the field set up as a number, I get a data type mismatch error. If I set it up as date time it comes in as:
12:00:53 am.

Can any one help me get into a format of 00:00:00 so that I can calculate the minutes and seconds.

 

[Trendsetter]

I think you need to use the Time Format functions look in help under Time there are specific ways of handling time only data