I Have a table with data, the first column containing a timestamp. I want to display only rows in that table with times between 5 hours ago and the current time. I've been trying to filter with the formula:

=FILTER(C2:H14, C2:C14 >= (NOW() - "008:00:00"), NOW())

and different variations on that. none seem to work. Any ideas?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.