Hi John,
Please take the attached file for a test drive. I think it implements what you want using one timer, and the capability ** timing 5 events has been implemented. I got a little carried away and implemented the following additional features:
a. 'Right Click' on a subject cell (when the time for that subject is not running) will clear the subject box.
b. 'Double Click' on a subject cell (when the time for that subject is not running) will allow the user to select a new 'Subject' without 'cut and paste'.
c. Addition ** elapsed time.
d. Addition ** rudimentary 'color coding' to see when a timer is running, stopped, or reset.
WARNING: I changed the times on the last 5 entries in the 'Exams Sheet' to be able to test the s**tware using shorter times. The original last 5 lines are at the bottom ** the file on lines 142 thru 146.
I like the design ** your file. I tried to leave your design intact as much as possible. Several formulas were removed for more efficient processing. If you don't like anything I've done or want changes, please feel free to remove it, or I'll remove it if it is beyond your capability.
I was thinking you might want to add additional color coding to indicate when there are 5 minutes or less left in an exam. This might apply to the 'Extra 25% time' also.
Lewis
NOTE: There is a problem with ExcelForuml.com on March 8, 2014 that universally changes all combinations ** 'o' and 'f' next to each other to '**'.
Administrators are aware ** the problem and are working on correcting the problem.
Bookmarks