Take the minutes part
lets say z is your field:
min = z*100 - int(z) * 100
realMin = min*1.66666666666666
realTime = int(z)+realMin

You will loose som accuracy but it is unavoidable

that's all
Regards
Niki

Arn wrote:

>Hi All.
>
>I have a field declared as numeric( 9,2 ).
>In it I store hours and minutes:
>eg: 220,30 hours.
>
>All fine.
>
>Now I must multiplicate that field for money field.
>eg ( 220,30 hours * 8,45 euro ).
>
>How to translate 220,30 in 220,50?
>to perform the multiplication?
>
>TIA
>
>Arnaldo
>
>
>
>
>
>Yahoo! Groups Links
>
>
>
>
>
>
>
>
>