As you have a clock, I'm assuming you're using some type of VBA/macro. You
should be able to stick this snippet into the appropriate place in your code
(after it updates cell)

'A1 is your clock cell
'A2 is your fluctuating price cell
'A3 is "snapshot" cell
If Range("A1").Value = TimeValue("10:30") Then
Range("A3").Value = Range("A2").Value
End If
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Scott520" wrote:

I have a clock running in Excel. Data in one cell is constantly changing. At
a specific time which I specify in a cell, I want the value in the cell that
is constantly changing, snapshot in another cell. How do I do this?
For example, stock prices, they are constantly changing on my spreadsheet
being linked to the internet, at 10:30 I want the price of IBM in a specific
cell.