Static Time

[pradeepdeepu_001]

Hi Guys,

I need to track the time taken by the user to update one application form.

We are a using a excel with Col A B C D (Data, Start Time, End Time, Total Time Taken)

When a user enters a number/string in Col A, thn in Col B the static current time should come and thn in Col C the current time should display, Col D the Diff of Col C and Col B

Ex.

A B C D
123 Current Time Current Time C-B

I have tried this for Col B +if(count(a1)>0,now(),""), it worked but the time is not static.....and need formula for Col C {Sumthng like "if Col B time is lesser than current time, then display current time, else blank" +if((b1)<now(),now(),"")}

Please help.

All your help will be much appreciated
Pradeep M