Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Converting to seconds
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Converting to seconds
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 -- Regards, Tom Ogilvy "Ramthebuffs" wrote in message ... Hey guys, I've been racking my brain on this for a while, its now late and I give up. Hopefully somebody can help. Basically the information I get counts seconds until you get to one minute, then it changes to 100. So pretty much what I need is to subtract 40 from 100 -159 and subtract 80 from 200-259. The numbers don't really go any higher. There are numbers below 100 as well. I started some code below, but its not really working because it still subtracts 40 from numbers under 1 minute(100). I'm sure you can tell I'm an amateur, just got stuck here. Any help would be greatly 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 If -- Ramthebuffs ------------------------------------------------------------------------ Ramthebuffs's Profile: http://www.excelforum.com/member.php...o&userid=16429 View this thread: http://www.excelforum.com/showthread...hreadid=277962 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
converting Minutes & Seconds into seconds | New Users to Excel | |||
Converting hh:mm:ss to seconds only | Excel Discussion (Misc queries) | |||
Converting to minutes and seconds | Excel Discussion (Misc queries) | |||
converting seconds in hh:mm:ss | Excel Discussion (Misc queries) | |||
Converting Julian Seconds with a macro to replace old seconds data | Excel Discussion (Misc queries) |