'google Sheets count Date and Time
can plz someone help me to correct my Funktion count number of cells with Date "Today" and Time "between 06:00 and 14:30"
=countifs('G:G">=Today() 06:00:00", 'G:G"<=Today() 14:30:00")
Solution 1:[1]
try:
=COUNTA(IFNA(FILTER('JIRA_Input SL'!G:G;
'JIRA_Input SL'!G:G>=(TODAY()+"06:00:00");
'JIRA_Input SL'!G:G<=(TODAY()+"14:30:00"))))
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 |