=TEXT(TIME(16,15*(ROW(A1)-1),0),"hh:mm")&"-"&TEXT(TIME(16,15*(ROW(A1)),0),"hh:mm")
--
Best Regards,

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


"YO" wrote:

it worked great! thank you very much!

perhaps you can further help me.
how can i do the same with quarters of an hour? :
16:00-16:15 16:15-16:30 16:30-16:45 16:45-17:00 17:00-17:15...

thank you