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?