At 09:43 AM 1/28/2001 +0100, Arnaldo wrote:

>Hi all.
>
>There is a way to subtract two fields ot type TIME in a computed fields?
>
>I have 2 fields say: 'FIRSTHOUR' and a second 'SECONDHOUR':
>
>if i do:
>WHOUR = COMPUTED BY ( SECONDHOUR - FIRSTHOUR ) but i got a COMPUTED
>numeric field:
>
>HOW EXTRACT TIME FROM THIS FIELD???

When you subtract one time from another, you get a result
that is not a time but a number of time intervals. Thus
12:00 - 08:00 = 4 hours, not 04:00 in the morning.


Regards,

Ann
www.ibphoenix.com
We have answers.