Dan If the column is time then I wouldn't think you could add it. In your example below for tech1 drive time you have 00:30:00 to the system it would mean 12:30am. I would think you have to store the time in integer or real columns.
Buddy ________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Dan Sent: Tuesday, April 29, 2008 2:08 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Need to Add Time to Time Hi all, Having a bit of trouble adding time to time in a report. Tech travels to a job for 30 mins works for 90 mins (both figures come from computed columns in the servtimes table. Tech Job Drive Jobtime Detail section: tech1 job1 00:30:00 01:30:00 tech2 job1 00:15:00 01:00:00 tech1 job2 00:45:00 01:00:00 ------------------------------------- totals S/B 01:30:00 03:30:00 I can't seem to find a way to compute these totals Dan Champion Service Department Manager Vredevoogd Heating & Cooling Grandville, MI. 49418 616-534-8271 x 14
