google Sheets count Date and Time-CodePudding

Home > OS > google Sheets count Date and Time

google Sheets count Date and Time

Time：04-11

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")

enter image description here

CodePudding user response：

try:

=COUNTIFS('G:G">=TODAY() "06:00:00"; 'G:G"<=TODAY() "14:30:00")