Starting with 16:00-17:00,

=ROW(A16)&":00-"&ROW(A17)&":00"

You can then copy this down and it will do what you want.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"YO" wrote:

hello.
i would like to drag down periods of hours.
what i mean is: writing down 16:00-17:00 lets say at A1
i would like to have the A column have 17:00-18:00, 18:00-19:00 etc

thank you