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...
If ignore Other column and Date, Time are located as
type in A3
=A2+1/24in B3
=B2+1/24select columns A and B starting from above cells and till end of your expected range, Ctrl+D.
Or drag them down.
- This worked for me. Very helpful, thank you!
achalla0 , glad it helped
