Seeing Warzel's adjacent post, I realize I completely misunderstood the
question. Ignore my suggestion.

Peter T

"Peter T" <peter_t@discussions wrote in message
...
Hi Alvin,

Could do that very easily manually -

A1: 09:00
A2: 10:00
select A1:A2
grab the little handle and drag down to A14
B2: =TEXT(A1,"hh.mm -") & TEXT(A2,"hh.mm")
double click the handle to fill down

maybe you prefer "h.mm" format

Or do you particularly need a VBA solution?

Regards,
Peter T

"Alvin Hansen" wrote in message
...
Hi
I want to make a loop in time format

like from 9:00 to 16:00
and with every half hour like
9:00 - 9:30 - -10:00 - 10:30
can i do that ?

Regards alvin