VBA \ Formula to List Intervals - 15 Minute Blocks

[t0ny84]

Hi,

I was wondering if anyone knows if it possible either via FORMULA or VBA to list the 15 minute interval times based on a supplied start and end time:

Example
C1 holds start time
C2 holds end time

User enters in the start and end times then below this it generates a list of intervals between these two times.

Thanks in Advance,
t0ny84

 

[Phuoc]

Try this

Book1
	A	B	C	D	E	F	G	H	I
1		Start time:	3:00
2		End time:	5:15
3	List
4	3:00
5	3:15
6	3:30
7	3:45
8	4:00
9	4:15
10	4:30
11	4:45
12	5:00
13	5:15
14
15
16
17
18
19
Sheet1

Cell Formulas
Range	Formula
A4:A17	A4	=IF($C$1+(ROWS($A$4:A4)-1)/24/4>$C$2,"",$C$1+(ROWS($A$4:A4)-1)/24/4)

 

[t0ny84]

Phuoc!​

You are awesome! Thanks so much! It works perfectly, now I just need to work out how to build the actual spreadsheet! (let the fun begin!)