Hi Jake,

In cell R1 put the date 1/1/08 (or whatever year you're starting with). Fill that down to row 366 (leap year!).

In cell S1 put the formula:
=OFFSET($C$1,(ROW(A1)*24-24)+(COLUMN(A1)-1),0)
Fill that formula right to column AP and down to your last row. Hopefully that does what you need.