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.
|