Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
macro with dynamic input | Excel Worksheet Functions | |||
Stopping a Timer / Running a timer simultaneously on Excel | Excel Discussion (Misc queries) | |||
Where is the FAQ? (for dynamic input lists) | Excel Programming | |||
Input Box Timer | Excel Programming | |||
Dynamic Macro Input | Excel Programming |