Time and date sequencing together.

[Avalanchez]

Hello,

I am trying to figure out the best way to create a time and date sequence that work together. I can get the time to work correctly with the sequence formula but Im not sure how to incorporate the date. Im trying to have one cell have date (B1) and the next the time (C1), when the rest of the rows below those see that date and time I want a 6 hour sequence to follow for the next 13 rows. Can this be done by formula or would VBA be easier?
EX:

Start Times	2/20/2023	12:00
6 hr	2/20/2023	18:00
12 hr	2/21/2023	00:00
18 hr	2/21/2023	06:00
24 hr
30 hr
36 hr
42 hr
48 hr
54 hr
60 hr
66 hr
72 hr
End

 

[Fluff]

You're welcome & thanks for the feedback.