I wish to filter timestamps on date and time using the filter option.
See extraction of the table I use below:
This column is formatted as 'Date & Time'.
Using the filter option rule: TimeStamp -> 'Date is today' I can not filter on time. By example I wish to filter the rows to be shown after 15:15:00.
Any idea on how to?
iMac (M4, 2024)
Surprisingly, the filters for "date" don't allow specifying the time of day. You can use a separate column that turns the time of day into a duration value and put a secondary filter on it. You can hide that column after you get it set up and running.
Formula in cell C2 =DURATION(,1)×TIMEVALUE(B)
Filter is shown in the screenshot but is not turned on.
Surprisingly, the filters for "date" don't allow specifying the time of day. You can use a separate column that turns the time of day into a duration value and put a secondary filter on it. You can hide that column after you get it set up and running.
Formula in cell C2 =DURATION(,1)×TIMEVALUE(B)
Filter is shown in the screenshot but is not turned on.
How to filter table timestamps by time
