VBA Code to return data if within X amount of hours

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.

Nevermind I think I found an answer using excel formulas.

I just used =C2=MEDIAN(C2,Ref!$AD$1:$AE$1) which tells me if the time is between X amount (whatever the user inputs), then based off that True or False result, used Sumifs to total the amount.

Thanks anyways