Results 1 to 3 of 3

Button used for capturing time (Timer)

Threaded View

  1. #1
    Registered User
    Join Date
    02-08-2009
    Location
    Michigan
    MS-Off Ver
    Several
    Posts
    2

    Button used for capturing time (Timer)

    I am looking for help with the following idea I am trying to attach a worksheet to show this but here is the basic idea


    When reading a water meter in a large apartment building
    a meter reader can also click a timer (LAP) button as the meter
    passes preset intervals. The worksheet would record the "lap times"
    in separate cells which could then be compared and usage figures
    can be calculated, allowing the meter reader to know if there is
    currently a Leak or other problem before leaving the premesis.

    In the attached worksheet you can see what I would like
    the meter reader enters the reading - the light green "Interval List"
    is created from that reading. The Meter reader then watches the meter
    clicking the LAP button each time the interval is passed, the current time
    is then stored to the Pink cells (Similar to the NOW() function), the times are then calculated in other cells like I did in the Blue column in this case showing elapsed time.

    I have tried several ways to do this using NOW, but each time all the cells are updated to NOW not just the current cell - and the Single Button woulod be really nice so the meter reader didn't have to look away from the meter.
    Attached Files Attached Files
    Last edited by mjcpeters; 02-09-2009 at 01:39 AM. Reason: Solved

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1