Repeationg same data row multiple times

I want to repeat the same date 24 times. The date sequence is to be generated from 1-Jan-2007 to 13-April-2013 by repeating one day, 24 times(indicating no of hours as in column B). And also it is required to calculate the mean Kt only counting non zero values for specified 24 intervals (indicated in column C).Number of Non zero values are different for each 24 hour intervals. Kindly help me. I hv attached the relevant file. Thank You very much.