splitting out timeframes
 

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

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