可以按日期和时间过滤Google表格结果,以适应当前时间? [英] Can I filter Google Sheets results by date and time relevent to current time?
本文介绍了可以按日期和时间过滤Google表格结果,以适应当前时间?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
解决方案
我设法创建这些公式
= filter(Sheet1!A1:C,Sheet1!C1:C& ; minus(now(),3),Sheet1!C1:C< minus(now(),12:00:00))
= ,Sheet1!A1:C),importrange(Key,Sheet1!C1:C)>减(now(),3),importrange(Key,Sheet1!C1:C < minus(now(),12:00:00))
I have a spreadsheet where sheet1 contains 1 text field of data and a date and time assigned to the data. On sheet 2 I need to have a filter that searches for an element in the text (using "=filter(sheet1!A1:A, search("search phrase", sheet1!A1:A))" to filter that part) but need to show only results where the time associated is for between 18hours - 3days before the current date and time. There is only one column of data other than the date and time, date and time is currently shown as "Date: 24.03.2013 11:04"
解决方案
I managed to create these formulas
=filter(Sheet1!A1:C, Sheet1!C1:C>minus(now(),3), Sheet1!C1:C<minus(now(),"12:00:00"))
=filter(importrange("Key","Sheet1!A1:C"), importrange("Key","Sheet1!C1:C")>minus(now(),3), importrange("Key","Sheet1!C1:C")<minus(now(),"12:00:00"))
这篇关于可以按日期和时间过滤Google表格结果,以适应当前时间?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文