DATETIME --> INTEGER

In order to track call lengths for billing purposes, my company needs to export a column from the call- tracking database to the billing database. The call- tracking column is in a DATETIME MINUTE to SECOND format while the receiving column requires an INTEGER. Essentially, I must find a way to turn 3:30 into 3.5. Everything I have tried (views, duration, etc.) hasn't worked. Does anybody have a suggestion short of changing the DATETIME format in the original table to an INTEGER? Thank you, Ken Norton -- KENNETH S. NORTON +================================+ Upgrade Corp of America | My opinions are barely my own, | 74437.1160@compuserve.com | and hardly my employer's. | aq069@freenet.buffalo.edu +================================+