Field Type for storing phone times

[jrothey]

Hello all. We're running MySQL 5.0.21 and have created a new table for calculating Customer Service phone call times for a month. I'm noticing the time values are referencing excel 1900 Time values, but not sure how to set the field type so that I can later calculate using a formula in Crystal against the data. I've tried both Time type and String type, but neither have been able to calculate relevant time since the time is upwards of 70 hours (70:34:21) as an example. Anyone familiar with this or what they found that resolved the calculation?

Thanks,
Jerrod

 

[r937]

excel 1900? no idea what that is

i would simply store the times as seconds in an INTEGER column

r937.com | rudy.ca
Buy my new book Simply SQL from Amazon