| Subject | Re: [ib-support] How to multiply a time value and a numeric value. |
|---|---|
| Author | Helen Borrie |
| Post date | 2001-10-04T01:14:42Z |
At 10:49 PM 03-10-01 +0300, Catagay Tengiz wrote:
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
>Hi to all,You need a start time and a finish time.
>
>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.
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