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 |
---|---|
61 | |
25 | |
14 | |
11 | |
6 |