Cell value not showing if 2 times are than less 1 Hr

[Harpman]

I have a sheet to calculate Break downs which could last from 1 minute to many days.

I need to the number of users affected when closed across a time line for the duration of outage. It works fine for outrages more than 1 hour but fails if less than 1 hr
Can anybody help and tell where I am going wrong suggest a better way?
Phillip


I am using =IF(AND(E2>=a2,E2<=b2),c2,"")

A2 = Start time 06/07/2011 10:01
B2 = End time 06/07/2011 13:16 (sometimes the downtime maybe more than one day)
C2 = Users Affected 500
D2 = Total Time 00:03:15

The time line runs from 08:00 to 00:00 anything from 00:01 to 08:00 is calculated as 08:00

E2 = 00:01 to 08:00 This is format as 06/07/2011 08:00 using =INT($P$2)+MOD(BE4,1) so that I can change the Date to as i log 30 days at a time.
F2 = 08:01 to 09:00 “ “ “
G2 = 09:01 to 10:00
H2 = 10:01 to 11:00
I2 = 11:01 to 12:00
J2 = 12:01 to 13:00
K2 = 13:01 to 14:00
L2 = 14:01 to 15:00
M2 = 15:01 to 16:00
And so on to 00:00

Regards

Phillip