Subject Re: [ib-support] How to multiply a time value and a numeric value.
Author Helen Borrie
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.