Need If/Then Formula That Changes With Time [Part2]

[artiststevens]

Hello,
This is Part2 to a post a made yesterday. I appreciate everyone who helped me to solve my problem but now I have a new one based on the same situation. After working with the formula I discovered that with me being on PST the formula needs tweaking. I need the formula to change at 21:00 and not at 0:00 and the date change. The original question can be found below. Time is better anyways so the formula can work in any time zone. Thanks for all the help. I attached the workbook.

Original Formula:

[code]=INDEX(Sheet1!$A$2:$C$14,MATCH(INT(SUBSTITUTE(A2,".","/")),Sheet1!$A$2:$A$14,0),3)[code]

[Can anyone help me with the following problem? I need a (IF/Then) formula that would paste the same number into a column from 0:00 to 23:00 and change the next day at 0:00 and do the same thing until the next 0:00. The data to be change every 24 hours is in Sheet1 and the date and time is in Sheet2. I attempted to use a formula that only recognizes 0:00 but with 23 spaces between days the next cell pasted is not the 2nd day. Please see the attached spreadsheet and any all help is greatly appreciated. Thank You.]

http://www.excelforum.com/excel-gene...with-time.html

[artiststevens]

Any further help?

[artiststevens]

Still looking for help. Thanks.

[artiststevens]

Another day another try.

[artiststevens]

Still looking for some guidance on this. Thank you.