Forum Discussion
Solved
Functions return the expected result at the real time.
Hi, Could have any function that returns the expected result with criteria is a period of specific time.? For example: SUMIFS with criteria is a time between 7:AM and 10:AM of date 2023-01-28. Ho...
=IF(AND(NOW()>=I6,NOW()<=I7),SUMIFS(Table1[sales],Table1[product],$J$3,Table1[units],$J$4),"")Maybe with this formula? I6 and I7 contain =44954+7/24 and =44954+10/24 which is equivalent for 2023-01-28 7:00:00 and 2023-01-28 10:00:00.
