I Want to Write numbers for date and time range

Hi,

I have date and time data in in column A in this format 1/14/2022 0:00.

i want in cell B2 0 should be written for this range
1/14/2022 0:00
1/14/2022 0:01
1/14/2022 0:02
1/14/2022 0:03
1/14/2022 0:04

5 should be written for this range
1/14/2022 0:05
1/14/2022 0:06
1/14/2022 0:07
1/14/2022 0:08
1/14/2022 0:09

10 should be written for this range
1/14/2022 0:10
1/14/2022 0:11
1/14/2022 0:12
1/14/2022 0:13
1/14/2022 0:14

and so on

(Sample file is attached for further details)

Although you are using a different username, this is a duplicate of this thread:

https://www.excelforum.com/excel-pro...-and-time.html

for which I have already given you an answer. You are not allowed duplicate threads on this forum, so mark this as Solved and continue in your other thread. A moderator will probably come along soon and Block this thread anyway.

Pete