Hi

C2's formula would be
=IF($B2-$A2<=C$1,1,0)

D2's formula would be
=IF(AND($B2-$A2<=D$1,$B2-$A2=C$1),1,0)

D2's formula can be copied to all your other columns (move your cursor over
the bottom right hand corner of D2 until you see a +, hold down your mouse
and drag across the columns). the C2 formula can be dragged down column C
and the other column's formulas can be dragged down for all your rows.

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Metalteck" wrote in message
...
IF my columns are formated as 0:15 to 1:00 what would be the difference in
the way that I type the formula and what would be the additional formula
be
for the extra columns.

"JulieD" wrote:

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.