Hi

what happens when you try the formulas i gave you in my previous post
---repost
=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've already go the time calculated in column W. I'm just trying to get it
to
reflect in the proper column. Right now, if w3 is :30
This is what I get.

w3....................ay.............az..........b a............bb
15 30 45 60
0:30..................0................1.......... .1..............1
0:10..................1................1.......... .1..............1

The formula I use in 15 is =--(W3<=15/1440)
In 30 is =--(W3<=30/1440) and so on...

Can you help me figure it out so that only 1 check mark is placed the time
instead of all of them.