Subject Re: [ib-support] How to multiply a time value and a numeric value.
Author Doug Chamberlin
At 10/3/2001 03:49 PM (Wednesday), =?iso-8859-9?Q?=C7a=F0atay_Tengiz?= wrote:
>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.

Could it be that you are confusing a "time" with a "duration"? I think time
field type is for a time of day value, not a duration of time. A duration
of time would be a floating point value, or integer value, using whatever
units of time measurement you care to use.