Overslaan naar inhoud
Menu
Je moet geregistreerd zijn om te kunnen communiceren met de community.
Deze vraag is gerapporteerd
2 Antwoorden
7875 Weergaven

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
Annuleer
Beste antwoord

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
Annuleer
Beste antwoord

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
Annuleer
Gerelateerde posts Antwoorden Weergaven Activiteit
0
mrt. 17
3975
1
mei 24
3473
3
okt. 24
34215
1
apr. 20
16000
2
mei 21
5256