Hello everyone I have two values, of Time type (IgnoreSeconds: true) : - MorningBeginningHour - MorningEndingHour
I want appsheet to calculate the duration in AppFormula area, something like: TotalHours = [MorningEndingHour] - [MorningBeginningHour]
But the appformula TotalHours doesn’t work!
Appsheet tells me it must be Duration type or Time type. I tried both but nothin changes…
Any idea?
Thanks,
Of course, I want this TotalHours to be shown
If your column types are time and your result column type is duration, you can calculate it like [MorningEndingHour] - [MorningBeginningHour].
Thanks Aleksi but… Error: "The expression is valid but its result type ‘Duration’ is not one of the expected types: Text "
Change the result column type to Duration
Thanks Aleksi. I understand why It wasn’t working: AppSheet don’t allow to change at the same time Column Type and Appformula.
Your solution works correctly when I change only the Column Type before saving. Then I put the Appformula and save again.
Actually… you can change them both at the same time if you don’t use expression builder.
Indeed, thanks again!
User | Count |
---|---|
42 | |
29 | |
25 | |
23 | |
13 |