Skip to Content
This question has been flagged
float_time
2 Respostes
7897 Vistes
Avatar
Sudhir Arya (ERP Harbor Consulting Services)

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.

Avatar
Descartar
Avatar
Abdul Nazar
Best 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

Avatar
Descartar
Avatar
Faris Fathurrahman
Best 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.​​​​​​​

Avatar
Descartar
Related Posts Respostes Vistes Activitat
How to hide float time field from group?
group_by float_time
Avatar
0
de març 17
4002
float_time widget display options
widget float_time odoo16
Avatar
Avatar
1
de maig 24
3516
Export float_time widget data into time format?.. Solved
export time float_time
Avatar
Avatar
Avatar
3
d’oct. 24
34233
Convert Hours and Minute into Float value Solved
time float_time V13
Avatar
Avatar
1
d’abr. 20
16060
Odoo 11: Wrong values when using widget float_time in qweb report
float_time Widgets qweb-report odoo11community
Avatar
Avatar
2
de maig 21
5270