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*.​​​​​​​

相关帖文	回复	查看
How to hide float time field from group? group_by float_time	0 3月 17	3977
float_time widget display options widget float_time odoo16	1 5月 24	3482
Export float_time widget data into time format?.. 已解决 export time float_time	3 10月 24	34223
Convert Hours and Minute into Float value 已解决 time float_time V13	1 4月 20	16016
Odoo 11: Wrong values when using widget float_time in qweb report float_time Widgets qweb-report odoo11community	2 5月 21	5261

此问题已终结

喜欢讨论吗？不要只阅读，加入进来！