modify vba to autoincrement hours

Happy Holidays everyone!

This is a VBA a member here wrote for me to convert a series of days into a series of days/ with 24 hours having a unique format for the hours (T00, T01, T02... T24).

Could someone help me modify it so that the output is now more conventional (still incremented hourly) in this format: 2017-11-30 21:00:00, 2017-11-30 22:00:00, 2017-11-30 00:00:00 etc?

I've tried but had no success in getting the hours to increment properly.

Please Login or Register  to view this content.

Originally Posted by jrtaylor

... modify it so that the output is now more conventional ... format:
2017-11-30 21:00:00, 2017-11-30 22:00:00, 2017-11-30 00:00:00 etc ...

Maybe this way:

Please Login or Register  to view this content.

but a lot depends on system settings (date, time, separators).

jrtaylor

Is this how you wanted?

Please Login or Register  to view this content.

Thanks! I'll try both. I see that the first is code which fits into the existing macro, while the second is a full macro?

Correct and my code is assuming ColA in original data have Dates without time.

If you have Date + Time in Original Data then change to

Please Login or Register  to view this content.