Formula time

[Cannone_Cannone]

HELLO
in a google sheet I have 2 columns with appasheet where I insert timetables.
the columns are of type time.
when I want to know the difference between 2 times I get this error on the sheet
Parameter 1 of the MINUS function includes number values, but “22:49:00” is text and cannot be interpreted as a number.
CAN ANYONE HELP ME?

[EIG]

This is not really an AppSheet question but a Google Sheets question but here is the answer:

stackoverflow.com

Add and Subtract Times

time, google-sheets, addition, duration

asked by Collin J on 07:31PM - 23 Nov 15 UTC

[Cannone_Cannone]

I could leave the formula on the sheet
how can i do with appsheet?
maybe creating a virtual column?

[MultiTech]

Wait… is this problem happening in google sheets or appsheet? The way I would set this up in appsheet is with three columns:

1. time1 | Type: Time, Initial Value: timenow()
2. time2 | Type: Time, Initial Value: timenow()
3. duration | Type: Duration, App Formula: [Time2] - [Time1] (assuming Time2 comes sequentially after Time1)

If this is happening in google sheets, check that the column type for both the columns is set; if you leave it to “Auto” Gsheets doesn’t get it right sometimes.

[Cannone_Cannone]

Sorry but I didn’t know how to solve!
anyway I tried but I always get the error

[MultiTech]

So both columns are the Time type, but when you use it in a formula it’s saying one of them is a text?

[Cannone_Cannone]

exact!!!

[Cannone_Cannone]

you are a genius!!!
I did as you said and everything works !!!