In D2 enter =A2
In E2: =IF(D2+TIME(0,15,0)<=$B2,D2+TIME(0,15,0),"")
copy E2 across as much as you need.

--
HTH

Bob Phillips

"soph" <soph@discussions.microsoft.com> wrote in message
news:D4C30CAD-F331-4A71-B48C-D2D04B401957@microsoft.com...
> Hi
>
> I currently have a data sheet that has activities for each person through
> the day noted as the start and end time only eg start:12:00 end:14:30. I
am
> trying create patterns for each day according to these activities down to
15
> minute intervals ie for the time noted above I want to see this broken
down
> to 12:00, 12:15, 12:30 etc to 14:15. Is there a way I can get excel to
split
> a timeframe into these sort of intervals?
>
> cheers
> Soph