ragavan
April 24th, 2005, 04:08 PM
Hi frd,
pls help me. In the access data base i have many fields.one is person name
and another is duration. Duration is in time foramt (eg- 2:34, 5:10) but "data type is text". i need to convert it into sec (2:34 in to 154 ) how can i do this.
or other wise i need to add all the duration fields. (1:10+1:10=2:20) is it possible?
pls help me. In the access data base i have many fields.one is person name
and another is duration. Duration is in time foramt (eg- 2:34, 5:10) but "data type is text". i need to convert it into sec (2:34 in to 154 ) how can i do this.
or other wise i need to add all the duration fields. (1:10+1:10=2:20) is it possible?