Hi,
I have attached the sheet I am working on. I am looking for value lookup and sum functions in a way that only looks particular values within an hour and gives the total of that at the start of the hour. For Eg: the time could be any between 6 Am to 7Am I'm looking to add any visits Between that to just show up as 6Am. And so on. I have described in the excel sheet how that would look. Any help would be appreciated. Thanks!
Bookmarks