| Subject | Re: [ib-support] How to multiply a time value and a numeric value. |
|---|---|
| Author | Doug Chamberlin |
| Post date | 2001-10-03T20:57:25Z |
At 10/3/2001 03:49 PM (Wednesday), =?iso-8859-9?Q?=C7a=F0atay_Tengiz?= wrote:
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.
>In my table I'm trying to calculate the cost of a person by multiplyingCould it be that you are confusing a "time" with a "duration"? I think time
>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.
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.