Subject | Re: [ib-support] TIME PROBLEM |
---|---|
Author | Svein Erling Tysvær |
Post date | 2002-03-30T01:51:25Z |
Tony,
your problem is that you want 1 = 0,6 in calculations, something I suspect
is impossible. To make calculations, you have to choose between
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 storing
things only as 20m = 0,20, 1h45m = 1,45, I think you have to write a UDF or
something to parse each value and transform to a format matching a) or b)
above before attempting to calculate anything.
HTH,
Set
your problem is that you want 1 = 0,6 in calculations, something I suspect
is impossible. To make calculations, you have to choose between
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 storing
things only as 20m = 0,20, 1h45m = 1,45, I think you have to write a UDF or
something to parse each value and transform to a format matching a) or b)
above before attempting to calculate anything.
HTH,
Set