Thread: Formula
View Single Post
  #4   Report Post  
Metalteck
 
Posts: n/a
Default

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.