Hello guys, I'm agregating data that I'm pulling out from different sheets with different time update. I have no way to change the time for the other sheets (I won't go into details it's complicated).
So I was wondering if there is a formula that can sumifs based on the time: ie if time before 2pm sum data from yesterday, and after 2 pm include data from today?