draging down time periods
 

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

draging down time periods
 

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

draging down time periods
 

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

draging down time periods
 

=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

draging down time periods
 

If you are replying to a previous message, it is always wise to quote enough
of the previous message to put your reply into context.

In this case you are replying (I believe) to the suggestion of using:
=ROW(A16)&":00-"&ROW(A17)&":00"

You might therefore want to develop the above suggestion into:
=INT(ROW(A64)/4)&":"&TEXT(MOD(ROW(A64),4)*15,"00")&"-"&INT(ROW(A65)/4)&":"&TEXT(MOD(ROW(A65),4)*15,"00")
--
David Biddulph

"YO" wrote in message
...
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