splitting out timeframes

G

Guest

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
 
B

Bob Phillips

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help please to get times of date into a graph 2
Time Duration Calculation help needed 4
How many are at work every hour in a 24-hour day? 2
Subtraction formula 7
How do I calculate time in excel (clock in and clock out 3
Calculation Total Time With Dates/Times That Overlaps 4
Conditional formatting in Excel 2010 2
excel timesheet and drop down boxes 3

Top