reading this in line with your reply in the original thread .. try
=IF($W3<=(AY$1/1440),1,0) formula in the 15 column - fill down

in the 30 column
=IF(AND($W3<=(AZ$1/1440),$W3=(AY$1/1440)),1,0)
fill across to the 45 & 60 and then down

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Metalteck" wrote in message
...
I currently have a field that subtracts the difference between an arrival
and
departure time. I have also created an additional 4 fields to see a time
frame for the time difference.

I placed the formulat =IF(W4<=15,1,0) in the 15 column, but it doesn't
seem
to be working correctly, just placing a 1 in the columns, regardless if it
is
over or under 15. I think it has to do with formatting it in proper time
format, but don't know how to do that. Can you help?