Hey all,
Hoping to find some help regarding the following issue (workbook attached).
Basically I have a table full of data (tab = 'Analysis'), in there is 'Date' (Column C) and 'Sugar Consumption' (Column W). On 'Sheet2', I want to be able to enter in an hour amount (in this case, 6 hours), and if the date & time in any of column C is within 6 hours, then display how much sugar will be used (either in a list as I have in the attachment, or in 'total consumption' - doesn't matter).
I have the table sorted by start time so it's easier to view.
So basically the end user would be able to type in any amount of hours, click the button, and all of the lines within that amount of time would display the sugar consumption.
Any ideas? Thank you in advance.
Bookmarks