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
|