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	3976
float_time widget display options widget float_time odoo16	1 5月 24	3476
Export float_time widget data into time format?.. 已解決 export time float_time	3 10月 24	34219
Convert Hours and Minute into Float value 已解決 time float_time V13	1 4月 20	16007
Odoo 11: Wrong values when using widget float_time in qweb report float_time Widgets qweb-report odoo11community	2 5月 21	5261

此問題已被標幟

喜歡這則討論？不要只閱讀，加入發表意見吧！