Forum Discussion
Auto-Filling Dates 24 separate times (24 hour clock)
I need to create a spreadsheet that shows the same date 24 times then moves to the next date.
For example -
| Date - | Time - | (Other Data) |
| 01/01/2017 | 00:00:00 | 5 |
| 01/01/2017 | 00:01:00 | 142 |
| .... | .... | ... |
| Then... | ||
| 01/01/2017 | 00:23:00 | 0 |
| 02/01/2017 | 00:00:00 | 42 |
Is there a way to insert it automatically or autofill it? (I have to produce two years worth of data)
Kindest regards
