Hi

if you got rid of the "m" in the 15m, 30m etc then it would mean less typing
for you:

assuming you have
...........A...............B................C..... ...........D.......................E
1.....Start.............Finish.........15......... .....30.......................45
2.....10:00...........10:15......

the formula for C2 would be
=IF($B2-$A2<=(C$1/1440),1,0)
the formula for D2 would be
=IF(AND($B2-$A2<=(D$1/1440),$B2-$A2=(C$1/1440)),1,0)

the formula for C2 could then be filled down column C
the formula for D2 could be filled accross row 2 and then down as many rows
as needed.

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Metalteck" wrote in message
...
I have a spreadsheet that counts the start and end times. I need to be able
get the difference between the two times. I then have columns that are
marked
15m, 30m and so on. If the difference between the two columns is less
then
or equal to 15, to count it, if not, count it wherever it's time frame
are.
Can you please help me out wit this.