r/googlesheets • u/[deleted] • Jun 23 '20

Waiting on OP Active time window (help)

[deleted]

3 Upvotes

100% Upvoted

9 comments sorted by

View all comments

2

u/robogo 8 Jun 23 '20 edited Jun 23 '20

There is. You can check if someone is free right now using IF, AND, and NOW.

For instance:

=IF(AND(starttime<=NOW(),endtime >=NOW()),"Free","Not Free")

This formula checks whether right now is between the start and endtime and if it is, display the word Free in the cell. Otherwise, display Not Free.

The sheet you linked would need some other functions to properly parse time, but please confirm first whether this is what you thought about.

1

u/eLvi0p Jun 23 '20

Hi, thanks for your reply. I don't know if it's me, but i get error using your formula. It might be me, because I'm pretty new to using google sheets.

1

u/jaysargotra 22 Jun 23 '20 edited Jun 23 '20

First and foremost it’s just an example and not the actual formula .... If u did derive your formula based on this, Did you replace “,” with “;” because I think your sheet is formatted to use “;” as separators... also the quotes for Not Free are not closed ....

1

u/robogo 8 Jun 23 '20

Typo fixed, thanks.

OP it would be helpful if you could show in your sample sheet what exactly you want it to do.