Need If/Then Formula That Changes With Time

Hello,
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.