Then just leave out the "given cell" in the True branch ( I guess your
use of "add" was confusing to me):

=IF(E7850, MOD(NOW(),1),"")

which will update whenever the worksheet is calculated.


In article ,
"Major Tomm" wrote:

This really didn't do it.
Hers an example of what I need,
If E785 is greater then 0, I need the system time to go into J785.

"JE McGimpsey" wrote:

one way:

Assume: "given cell" is A1

=IF(A10,A1 + MOD(NOW(),1),"")

Format as time if necessary.

In article ,
"Major Tomm" wrote:

I am trying to create a formula that would add the current timefrom my
computer to a given cell if the an other given cell is greater then 0