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

Related Posts	Replies	Views
How to hide float time field from group? group_by float_time	0 mars 17	4939
float_time widget display options widget float_time odoo16	1 maj 24	5629
Export float_time widget data into time format?.. Solved export time float_time	3 okt. 24	36011
Convert Hours and Minute into Float value Solved time float_time V13	1 apr. 20	17688
Odoo 11: Wrong values when using widget float_time in qweb report float_time Widgets qweb-report odoo11community	2 maj 21	6690

This question has been flagged

Enjoying the discussion? Don't just read, join in!