Excel 2007 : Multiple If Statment

Hi

I'm trying to write a formula that brakes the times below down to 15 minute intervals.

I was hoping someone would be able to help. I guess I need to use multiple of statments but not sure how to do it.

Can anyone help please?

This is what i have so far.

=IF($H$2>$Y$1,0,1)

H I
Start Time End Time
00:15 14:15
08:00 20:30
07:45 09:15
13:00 20:00
11:30 19:45

The table I want to populate looks like this.

Y Z AA AB
00:00 00:15 00:30 00:45

Thanks. Problem solved. The user cant input values that cross over midnight.

Hi. After using the tool for a few weeks the user has decided that the times must be able to cross midnight. For example if the Start is 20:00 and End of 06:00 ... I would want to record the 20:00 to 23:45 at the right end of your matrix and 00:00 to 06:00 from the left.

Would anyone know how to achieve this?

my formula so far is

=($M2<=Q$1)*($N2>=Q$1)

M= start time
N= Finish time
Q= Time header in the matrix

many thanks