unknownmuncher
Technical User
I've got a spreadsheet (in Excel) that is intended to be used "live" - that is, the data that is currently showing on the sheet is what is happening at that time - there is no record being taken.
One of the things I need done for this spreadsheet is to make it so that when a certain cell hits a certain value (actually, one of several, but that's no problem), a timer starts until the cell hits certain (set of) different value(s, but once again, the plurality isn't a problem). I would like the timer to be constantly updating and somewhere instantly accesible, like in one of the cells in that worksheet.
I originally tried to do this by setting up a "trigger" cell that would output =NOW() when its trigger happened and by having a macro constantly update another cell that would be the difference between that cell and the current time, but the problem with that was twofold: The trigger cell would calculate when the difference cell calculated, and the macro ran in the foreground, preventing me from changing other aspects of the sheet.
Any suggestions for implementing what I need done?
One of the things I need done for this spreadsheet is to make it so that when a certain cell hits a certain value (actually, one of several, but that's no problem), a timer starts until the cell hits certain (set of) different value(s, but once again, the plurality isn't a problem). I would like the timer to be constantly updating and somewhere instantly accesible, like in one of the cells in that worksheet.
I originally tried to do this by setting up a "trigger" cell that would output =NOW() when its trigger happened and by having a macro constantly update another cell that would be the difference between that cell and the current time, but the problem with that was twofold: The trigger cell would calculate when the difference cell calculated, and the macro ran in the foreground, preventing me from changing other aspects of the sheet.
Any suggestions for implementing what I need done?
