LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 17
Default Dynamic Input Timer

I would like have code in the sheet module that calculates the elapsed time
it takes a user to enter data into the spreadsheet. For example... A user
first data entry is in column "A" and last data entry is in column "E". I
would like to start a clock when they enter the data in column "A" and stop
it when the data in column "E" is entered and output to elapsed time in
column "F". Data will continue to be entered in descending order by row
every hour or so... that's why I believe the code needs to be dynamic in the
sheet module.

Input 1 Input 2 Input 3 Input 4 Input 5 Total Input Time
1 2 3 4 5 0:01:42
1 2 3 4 5 0:02:12
1 2 3 4 5 0:02:42
1 2 3 4 5 0:03:12

Any suggestions would be appreciated... thanks!

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
macro with dynamic input Ahmaq Excel Worksheet Functions 2 April 24th 07 01:06 PM
Stopping a Timer / Running a timer simultaneously on Excel Paul23 Excel Discussion (Misc queries) 1 March 10th 06 12:08 PM
Where is the FAQ? (for dynamic input lists) Shannon Jacobs Excel Programming 1 February 1st 06 04:10 PM
Input Box Timer Michael Smith Excel Programming 2 October 28th 05 07:36 PM
Dynamic Macro Input Craig[_9_] Excel Programming 3 November 10th 03 08:55 PM


All times are GMT +1. The time now is 06:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"