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.
How can the function return the expected result at that real time?
=SUMIFS(Table1[sales],Table1[product],$J$3,Table1[units],$J$4,Table1[Date],$I$3)
Any ideas, please.
Thank you.
=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.
2 Replies
=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.
