Dan,
Convert the times to (integer) minutes then do the math. Emmitt Dove Manager, DairyPak Business Systems Evergreen Packaging, Inc. [EMAIL PROTECTED] [EMAIL PROTECTED] (203) 643-8022 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
