Auto-Filling Dates 24 separate times (24 hour clock)

[TomHiggs]

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

[#2]

@TomHiggs 

If ignore Other column and Date, Time are located as

type in A3

=A2+1/24

in B3

=B2+1/24

select columns A and B starting from above cells and till end of your expected range, Ctrl+D.

Or drag them down.

[#3]

This worked for me. Very helpful, thank you!

[#4]

@achalla0 , glad it helped