Formula time

AppSheet AppSheet Q&A
1

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?

2

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

3

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

4

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

5

exact!!!

6

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

7

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.

8

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

1 Like