Functions return the expected result at the real time.

Frequent Contributor


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?





Any ideas, please.

Thank you.


1 Reply



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.

specific time.JPG