Convert Time Frame To Quarter Hour Intervals

[ralpha17]

Hi,

I'm trying to convert a time frame into fifteen-minute intervals. I have a start time and an end time; I need to split these into quarter hours. For instance:

18:00 in A1 then 20:00 in A2

I need to show the intervals included within these two times, meaning 18:00, 18:15, 18:30, 18:45, 19:00, 19:15, 19:30 & 19:45.

I have over 2,000 rows of data I need to "translate" to intervals of fifteen-minutes.

Any insight is greatly appreciated.

 

[cyrilbrd]

Hi. try in B2 =IF(A1="","",IF(A1+0.0104166666666666>=$A2,"",A1+0.0104166666666666)) copied right till needed.

 

[ralpha17]

Thank you very much for getting back to me. I'll try that and post back whether it worked for me or not. Thanks.