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