Set var vTime = (ADDMIN(.vTime,IMIN(.vAddTime)))

Dennis Mcgrath

________________________________
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Emmitt Dove
Sent: Tuesday, April 29, 2008 1:37 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - RE: Need to Add Time to Time

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

Reply via email to