Fill series by hour
I think there should be a simple solution to this, but it is escaping me. I'm creating a food diary, and want to make one column show the date, and the next column show every hour of that day. Ea...
Forum Discussion
For Fill Series, you only need to select the cell with 0:00 AM.
In the Fill Series dialog, select Columns.
Enter 0.041666666666666666 in the Step box and 0.9583333333333333333 in the Stop Value box.
Or:
Type 12:00 AM in a cell and 1:00 AM in the cell below.
Select the two cells, then drag the fill handle in the lower right corner of the selection down.
That's a little more complicated than the answer from OliverScheurich, but it works just as well. Thank you so much!