Conversion from float_time to float

Question

As we all know that we can use float field for time with the help of widget="float_time" .

Now, my question is that how this float_time value is calculated/converted into float value.

*Ex:*

I am giving value *00:10* in my form and when I look into the db it shows *0.16666667*.

Thanks in advance.

Abdul Nazar · Answer

The odoo will convert float to float_time like below

# Import math Library
import math
input_value = 0.16666667
hours, minutes = divmod(input_value * 60, 60)
result = '%02d:%02d' % (hours, minutes)
print(result)

*Output: 00:10*

Faris Fathurrahman · Answer

The number
*0.16666667 *was obtained from the division between *10* divided by *60* (rounded version of the real amount which is *0.16666666666
*​...). The formula happened because of the relation between *minute* and *second* where *1 minute* = *60 seconds*. Therefore, in this ​
widget="float_time" case, Odoo converted the *10 seconds* into the amount determined in *minute*.​​​​​​​

Aiheeseen liittyviä artikkeleita	Vastaukset	Näkymät
How to hide float time field from group? group_by float_time	0 maalisk. 17	4675
float_time widget display options widget float_time odoo16	1 toukok. 24	5050
Export float_time widget data into time format?.. Ratkaistu export time float_time	3 lokak. 24	35604
Convert Hours and Minute into Float value Ratkaistu time float_time V13	1 huhtik. 20	17260
Odoo 11: Wrong values when using widget float_time in qweb report float_time Widgets qweb-report odoo11community	2 toukok. 21	6336

Tämä kysymys on merkitty

Nautitko keskustelusta? Älä vain lue, vaan osallistu!