>2- Which is the best way to deal with time in table fields, numeric or character ?
I use character fields for the time (in line with what TIME() returns). Most time the user actually only needs hours an minutes, so these fields are C(5) fields. For calculations I've a one line function that converts this to minutes.
--
Christof