You can try this but you have to Careful, this could tie up your system if you do it too long. So for this open a new work book, right click and view code paste this in the window
Code:
Sub Clock()
'Create an iteration counter
For i = 1 To Range("b1")
'Recalculate the worksheet
Worksheets("sheet1").Calculate
'Update the worksheet with the latest iteration number
Range("b2") = i
'Increment value of i by i
Next i
End Sub
In cell a1 =now() format to desired time view in cell b1 enter a number, 5000 would be a good start. Then go to tools-macro-select clock-run.
Bookmarks