very true Dawn,
and that has happened on a couple of my techs service calls, we
just create two calls.... one before midnight and one after. I
wouldn't mind seeing this work right (bad choice of words) if it had
a DATE/TIME rather than just a date.
How do payroll people do this, you would think this is a well,
documented need, and a plethora of applications to do something like this.
At 04:28 PM 4/29/2008, you wrote:
Dan,
It only works because none of your times cross the midnight
mark. For instance, if the jobstart was 23:00 (11:00 P.M.), and the
jobend was 00:45 (12:45 A,M.), the subtraction would yield a
negative number, and I believe the RTIME function would turn that to NULL.
Dawn Hast
Dan <[EMAIL PROTECTED]> wrote on 04/29/2008 04:02:49 PM:
>
> I guess I still don't get why I can subtract time from time, but
not add it.
> My computed columns work perfectly (or at least, the way I expect)
>
> TravelTable (computed columns)
> column1 column2 column3 column4 column5 column6
> trvestart jobstart jobend traveltime jobtime totaltime
> 12:47:01 13:35:05 14:45:01 00:48:04 01:09:56 01:58:00
>
> The computed columns are (RTIME(0,0,(jobstart- travelstart)))
>
> so subtraction works like I would hope.
> Why not addition?
>
> Anyways Guess I need a work around.
> so, at the detail level, I need to convert time to int, then add it
> and convert it back?
>
>
>
>
> I am not following your example very well.
>
> At 03:06 PM 4/29/2008, you wrote:
> 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
>
> Dan Champion
> Service Department Manager
> Vredevoogd Heating & Cooling
> Grandville, MI. 49418
> 616-534-8271 x 14
>
Dan Champion
Service Department Manager
Vredevoogd Heating & Cooling
Grandville, MI. 49418
616-534-8271 x 14
