View Single Post
  #2   Report Post  
JE McGimpsey
 
Posts: n/a
Default

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