Converting to seconds

[Ramthebuffs]

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

 

[Tom Ogilvy]

Dim cell as Range
For each cell in Range("AC1:AC10")
Select Case cell.Value
Case 0 to 99.99
Cells(cell.row,"CC").Value = cell.Value
Case 99.99 to 199.99
Cells(cell.row,"CC").Value = cell.Value - 40
Case 199.99 to 299.99
Cells(cell.row,"CC").Value = cell.Value - 80
End Select
Next