converting text data type into number 1

[srd]

Hi!

I have a series of time data that are formated into text data type (e.g. 1:00, 7:32 (min:secs)), but I need to analyze it and have to do some operations with it. When I try to change the data type I get some errors...

Is there a way to convert it, without lossing info and at the sametime not time consuming?

Many Thanks in advanced

sIMAO d.

 

[mpastore]

I assume you want to convert your text time to a decimal representation of time, i.e. 7:30 will be 7.5.

CDbl(Left([mytime], InStr([mytime], ":&quot - 1) + (CLng(Mid([mytime], InStr([mytime], ":&quot + 1)) / 60))

In a query you might do:

select CDbl(Left([mytime], InStr([mytime], ":&quot - 1) + (CLng(Mid([mytime], InStr([mytime], ":&quot + 1)) / 60)) as mytime_dec
from mytable

Mike Pastore

Hats off to (Roy) Harper

 

[srd]

And If instead of 00(mins):00(secs) I would have 00(hours):00(mins):00(secs)?

And yes I would like to change it to a decimal number of minutes (X,xxx mins).

Thank you

sIMAO d.

 

[mpastore]

Assuming a properly formatted text (00:00:00):

CDbl(Left([mytime], 2)) + (CDbl(Mid([mytime], 4, 2) / 60)) + (CDbl(Right([mytime], 2) / 3600))

Mike Pastore

Hats off to (Roy) Harper