Duration/Number triggers "invalid operator" error

[Har]

Trying to do a simple expression which seems to be straight forward in the appsheettraining samples and training. Need to calculate the price for a task: [Hours] * [HourlyRate]. However, I'm getting "has an invalid operator" error. Hours are calculated for "duration": ([EndTime]-[StartTime]). When I change from duration to decimal, the price error goes away, but get "app formula 'Duration' does not match the column type"; the same if using "number". All of this particlar work is on the same table.

[Steve · Accepted solution]

A Duration is not a numeric value. You'll need to use TOTALSECONDS(), TOTALMINUTES(), or TOTALHOURS() to convert a Duration value to a numeric value.

Date and time expressions - AppSheet Help

Search results - AppSheet Help

[Har]

Thank you