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 319
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