Subject Re: [ib-support] How to multiply a time value and a numeric value. Helen Borrie 2001-10-04T01:23:43Z
Oh, and the start time and finish time should be TIMESTAMP, not TIME, in order to avoid the complication of having to to calculate a "day's complement" where the start time is before midnight and the finish time is after midnight.

H.

At 11:14 AM 04-10-01 +1000, I wrote:
>At 10:49 PM 03-10-01 +0300, Catagay Tengiz wrote:
> >Hi to all,
> >
> >In my table I'm trying to calculate the cost of a person by multiplying
> >person's hour rate by working time.
> >
> >So I got a hourly rate value a numeric field and working time a time field.
> >
> >When I try to multiply these I get an error.
>
>You need a start time and a finish time.
> Subtract start time from finish time to get duration in days
> Multiply that result by 24 to get duration in hours.
> Multiply that result by the hourly rate to get the cost.
>
>TIME is confusing for non-native-English speakers! In English we say "what is the time?" whereas other in other languages you say "what is the hour?" The answer to this question is a TIME value.
>
>But in English we also want to know the "time it took to do something". This means a period of duration, interval, etc., and it is not a TIME value but a double.
>
>hth
>Helen
>
>
>To unsubscribe from this group, send an email to:
>ib-support-unsubscribe@egroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/