N() function

N() is a google sheets function, what is the equivalent in appsheet?

I want to compare a column of [START time] (type TIME) with TIMENOW() function, but it doesn’t work.

In sheets I get it to work by getting the serial number of the [START time] with N() and that allows me the operations I need.

https://support.google.com/docs/answer/3093357?hl=en

There is no exact equivalent. But you could try NUMBER() or, maybe EXTRACTNUMBERS()

How doesn’t it work? What exactly did you try?

What is a “serial number” of a Time value?

2 Likes

Why??? Even in Sheets, that’s a complex solution to a simple problem. Times can be compared directly.

1 Like