Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

HELP! Time Conversion

Status
Not open for further replies.

LongFeiFengWu

Technical User
Nov 9, 2001
98
US
I have a collection of fields in a database that are input as text (trying to change the field type to date/time or number causes the db to erase the data in those fields). The format is hh:nn:ss. I need to turn those fields into minutes. So if I have 60:10:00 I need it to say 3610.

Any help is appreciated.

"If nothing within you stays rigid, outward things will disclose themselves. Moving, be like water. Still, be like a mirror. Respond like an echo." ~ Bruce Lee
 
Should get you there faq333-3194


General FAQ faq333-2924
5 steps to asking a question faq333-3811
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top