Subject | Re: TIME PROBLEM |
---|---|

Author | apatri2000 |

Post date | 2002-03-26T15:31:14Z |

--- In ib-support@y..., Svein Erling Tysvær

<svein.erling.tysvaer@k...> wrote:

Sven, thanks.

You are always full helping.

THANKS.

Tony

<svein.erling.tysvaer@k...> wrote:

> Not having appeared at its target 3 and a half hours after I sentit,

> whereas other messages appears instantly, I've decided to resend myanswer:

Sven, thanks.

You are always full helping.

THANKS.

Tony

>suspect

> >Date: Tue, 26 Mar 2002 08:30:31 +0100

> >To: ib-support@y...

> >From: Svein Erling Tysvær <svein.erling.tysvaer@k...>

> >Subject: Re: [ib-support] TIME PROBLEM

> >

> >Tony,

> >your problem is that you want 1 = 0,6 in calculations, something I

> is impossible. To make calculations, you have to choose betweenstoring

> >

> >a) store everything as minutes (i.e. 20m = 20, 1h45m = 105)

> >b) store everything as hours (i.e. 20m = 0,3333, 1h45m = 1,75)

> >

> >Whichever you choose, calculations become simple. If you insist on

> things only as 20m = 0,20, 1h45m = 1,45, I think you have to writea UDF or

> something to parse each value and transform to a format matching a)or b)

> above before attempting to calculate anything.

> >

> >HTH,

> >Set