Static Time

**pradeepdeepu_001** · 09-19-2011, 05:43 AM

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

**Bob Phillips** · 09-19-2011, 05:45 AM

Please Login or Register  to view this content.

**pradeepdeepu_001** · 09-19-2011, 05:48 AM

Bob,

Thnx...but i have never used vba or macro and not sure how to implement this code........so req u to please help me with a formula to execute

**Bob Phillips** · 09-19-2011, 05:51 AM

A formula won't do it, because if you add =NOW() into a cell it will continually update, that is, it will not be static.

**pradeepdeepu_001** · 09-19-2011, 05:55 AM

Okay, thnx for clarification Bob
Can u please help me how to run this code or command........I have copied the code u have mentioned and pasted it in a VBA editor.....thn wat to do next??