Time intervals

[endri81]

I want to create 10 minutes intervals in a 24h day automatically.
Intervals should begin at 06:00 AM and seem like :
06:00-06:10
06:10-06-20
..
07:00-07:10
...

23:50-24:00

Is it possible?

Best Regards

 

[GTO]

Try:
<font face=Courier New><SPAN style="color:#00007F">Sub</SPAN> exa7()<br><SPAN style="color:#00007F">Dim</SPAN> dbl <SPAN style="color:#00007F">As</SPAN> <SPAN style="color:#00007F">Double</SPAN><br><SPAN style="color:#00007F">Dim</SPAN> dtm <SPAN style="color:#00007F">As</SPAN> <SPAN style="color:#00007F">Date</SPAN><br><SPAN style="color:#00007F">Dim</SPAN> i <SPAN style="color:#00007F">As</SPAN> <SPAN style="color:#00007F">Long</SPAN><br>    <br>    dbl = 1 / 86400 * 600 * 35<br>    <br>    <SPAN style="color:#00007F">Do</SPAN> <SPAN style="color:#00007F">While</SPAN> dbl < 0.99<br>        i = i + 1<br>        dbl = dbl + 1 / 86400 * 600<br>        dtm = <SPAN style="color:#00007F">CDate</SPAN>(dbl)<br>        Cells(i, 1).Value = Format(dbl, "hh:mm") & "-" & Format(dbl + 1 / 86400 * 600, "hh:mm")<br>    <SPAN style="color:#00007F">Loop</SPAN><br><SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN></FONT>

 

[T. Valko]

I want to create 10 minutes intervals in a 24h day automatically.
Intervals should begin at 06:00 AM and seem like :
06:00-06:10
06:10-06-20
..
07:00-07:10
...

23:50-24:00

Is it possible?

Best Regards

Using a formula...

Manually type in the first interval in cell A1:

6:00-6:10

Enter this formula in A2:

=TEXT(LEFT(A1,FIND("-",A1)-1)+"0:10","h:mm")&"-"&TEXT(LEFT(A1,FIND("-",A1)-1)+"0:20","[h]:mm")

Copy down to A108