Hi

if you have already subtracted the columns you can then just test ... but i
can't work out what column the 0:30 is in, nor the 15, 30, 45, 60

please post back with cell references.


--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Metalteck" wrote in message
...
On the spreadsheet, I got an individual field that tells me calculates the
time difference, and works fine as shown.
Q3 T3 W3 15 30 45 60
2:30 3:00 0:30 1 0 0 0

But to actually make it know where to place the count is not working. It
only places it in the 15 column.

You've helped me in the time difference, how do i get the count to be
recognized in the proper column. I don't think I need it to calculate the
difference in the time frame columns, just count. But I'm asking you for
help, your the expert.

=IF($W3-$R3<=(AY$1/1440),1,0) formula in the 15 column.

=IF(AND($W3-$R3<=(AZ$1/1440),$W3-$R3=(AY$1/1440)),1,0) is the formula for
the rest of the column