Hi everyone,

Could you tell me the best Data Type to use to store time in a DB?

I need to store cumulative hours and minutes rather than an actual time - so I might need 255 hours and 35 minutes for example. I believe that the TIME data type only stores actual times of the day (e.g. 15:45).

Would I be better just to store the hours and minutes as separate fields with a varchar Data Type and just do some maths to get the exact end figure for display purposes as obviously the minutes field would be more than 60?