Hello everyone :) I have two values, of Time ...

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,

0 7 315
7 REPLIES 7

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!

Top Labels in this Space