Hey guys, I've been racking my brain on this for a while, its now lat
and I give up. Hopefully somebody can help.

Basically the information I get counts seconds until you get to on
minute, then it changes to 100. So pretty much what I need is t
subtract 40 from 100 -159 and subtract 80 from 200-259. The number
don't really go any higher. There are numbers below 100 as well.
started some code below, but its not really working because it stil
subtracts 40 from numbers under 1 minute(100). I'm sure you can tel
I'm an amateur, just got stuck here. Any help would be greatl
appreciated.

Oh yeah, I'm converting AC1:AC10 in this manner.


If Range("AC1") 59.99 Then Range("CC1").Value = Range("ac1") - 40
Range("AC1").Select
ActiveCell.FormulaR1C1 = "=RC[52]"
ElseIf Range("AC1") < 59.99 Then Range ?????
End I

--
Ramthebuff
-----------------------------------------------------------------------
Ramthebuffs's Profile: http://www.excelforum.com/member.php...fo&userid=1642
View this thread: http://www.excelforum.com/showthread.php?threadid=27796