Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time Periods Chart Question | Charts and Charting in Excel | |||
How to measure time for processing periods? | Excel Discussion (Misc queries) | |||
Calculating overlapping time periods | Excel Worksheet Functions | |||
periods of time | New Users to Excel | |||
calculate time periods | Excel Worksheet Functions |