All geek questions in one place

Using cell values ​​based on time of day

I need to create a spreadsheet that is supposed to extract data from a cell depending on the time of day.

In column "A" I have all the hours of the day, from 0 to 23; in column "F" I have a series of arbitrary numbers related to the usage behavior that I am tracking.

I would like to create a formula that, for example, at 4 pm, will show me the value of column "F" associated with the number "16". Example: at midnight, get the value of the "F" column associated with A1 (which is 0 because it is midnight), then F1 = X (where X is an arbitrary number in row 1).

Any ideas?

+4
source share
1
   =vlookup(HOUR(NOW()),$a$1:$f$24,6,0)
. NOW() , Hour , vlookup 6- .
+2

Source: https://habr.com/ru/post/1606763/

More articles:


All Articles