Results 1 to 3 of 3

Problem using time and formulas with a form

Threaded View

D3Pratt Problem using time and... 03-27-2009, 10:15 AM
D3Pratt Re: Problem using time and... 03-27-2009, 05:01 PM
D3Pratt Re: Problem using time and... 03-28-2009, 02:21 AM
  1. #1
    Registered User
    Join Date
    03-25-2009
    Location
    San Jose
    MS-Off Ver
    Excel 2007
    Posts
    83

    Problem using time and formulas with a form

    I want to click a command button on a form and populate a cell with a time stamp in HH:MM format, AND have it show in a text box next to the button.

    Well, actually two buttons, one for start, one for stop.

    Then I want to have the worksheet calculate the elapsed time and show that on the form in the same HH:MM format.

    The problems I'm encountering:

    1)The form overwrites the formula the way I have it set up.
    2)I can't get the time to be shown on the form in the HH:MM format
    Attached Files Attached Files
    Last edited by D3Pratt; 03-28-2009 at 02:22 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