mercredi 18 septembre 2019

Filter function for cells with Date Time values

I have a spreadsheet where the cells in column A are in Date Time format (DD/MM/YYYY HH:MM)

I am trying to filter only cells where Date Time values are greater than the current time

I have tried to use various forms such as DATAVALUE and TIMEVALUE, TEXT, but in all of them when I try to use the FILTER function it delivers all cells as if they were all future dates, but they are not.

Here is the spreadsheet link for anyone who can help me solve this problem:

https://docs.google.com/spreadsheets/d/1bvZ1YbeVFGSPoA21D3mqNIVOrYxRGmoGUWnzEwNZ8QQ/edit#gid=963792412

Note, the cell I am trying to use FILTER is I2

Aucun commentaire:

Enregistrer un commentaire