Steve,
Yes, in the table they do on occasion. For this report, I was
going to ignore those, but to be accurate, I do need to consider them
as well. I might rethink my computed columns at this point. Whew
what a kettle of fish I am boiling.
13 techs running 6+ calls a day and I need to draw up a
profitability report down to the minute. Some of the calls are after
hours (so time and a half) some are emergency, so Double time.
This ones going to keep me busy for a week I bet.
At 05:43 PM 4/29/2008, you wrote:
Dan, now that Bill has given you a proper solution, do/could any
call cross over the dateline, i.e. the witching hour of midnight (12:00am)?
If not, no prob'.
If so, I think you might have to consider DATETIME types as part of
the solution mix.
My time-devalued $0.02,
Steve in Memphis
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Dan
Sent: Tuesday, April 29, 2008 4:22pm 16:22
To: RBASE-L Mailing List
Subject: [RBASE-L] - RE: Need to Add Time to Time
Perfect solution... Thanks, just what I needed.
At 04:49 PM 4/29/2008, you wrote:
vtotalseconds INT = +
( (IHR(.drive) * 60 * 60) + (IMIN(.drive) * 60) + (ISEC(.drive)) )
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
