New Bug Encountered:decimal conversion to Time value

[Rousseau_Etienn]

The formula is very genious , but please note that it seems to work when [hours] column is decimal with only one decimal digit Regards

Duration from Decimal Hours

Convert a number of hours expressed as a Decimal value to a Duration value.

(  TIME(    CONCATENATE(      MOD(FLOOR([Hours]), 24),      ":",      (MOD(((60 * 60) * [Hours]), (60 * 60)) / 60),      ":",      MOD(((60 * 60) * [Hours]), 60)    )  )  - "00:00:00")+ (FLOOR([Hours] / 24) * 24)

etienne

[1minManager]

Sounds like a rounding issue somewhere. Is this in a virtual or normal column?

Simon@1minManager.com

[Rousseau_Etienn]

its a product of several columns , some being virtual and other normal ?

but you are right , when using normal column , only decimal rounded to ,05 seems to work . Generally with one decimal digit it seems to work at each time .

Regards

etienne

Le jeu. 24 oct. 2019 à 11:14, Simon Robinson via AppSheet Creator Community appsheet@discoursemail.com a écrit :

[1minManager]

Ok, had this mutiple times. So it sounds like an Appsheet bug. So you’ll have to submit it to support@appsheet.com.

But before that, it would help them and you to isolate exactly which column and or function is causing this. Here’s what I’d do

1 = Split up your formula into different elements, e.g.
a = MOD(FLOOR([Hours]), 24)
b = MOD(((60 * 60) * [Hours]), (60 * 60)) / 60
c = Concatenate…

Once you’ve then worked out which bit ir wrong, dig deeper to isolate the exact bit

In my experience, if you do this, they usually release a fix in a day or so

Simon@1minManager.com

[Rousseau_Etienn]

Thank you

I fixed the problem with limiting to one decimal digit in all columns involved in the final product , to be converted in time

Have a good day

Le jeu. 24 oct. 2019 à 12:16, Simon Robinson via AppSheet Creator Community appsheet@discoursemail.com a écrit :