+ Reply to Thread
Results 1 to 3 of 3

Creating a Time elapsed Spread Sheet that records and posts time...

  1. #1
    Forum Contributor
    Join Date
    03-14-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    491

    Creating a Time elapsed Spread Sheet that records and posts time...

    Hello,

    I am trying to figure out whether or not it is possible to create a macro that would allow a user to click on a button...

    We'll call this button "Start Timing"
    at the time that this button is clicked, I want VBA to post that time in a cell in a column Labeled Start.
    for example...

    If I clicked on "Start Timing" at 10:30 am then the first entry would read 10:30 am respectively.

    The other button would read..."Stop timing"
    And whatever time it happens to be when I click stop timing should reflect in the next column labeled Finish.
    So If I stopped timing at 10:45 am then the spread sheet would look something like this...

    Start Finish
    10:30a 10:45a

    and the next time I click on Start... the time would begin to record in the next row...etc...

    Finally in another module...I would like to have it where I can email the results on the spreadsheet.

    Any help or guidance would be much appreciated. -Thank You

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Creating a Time elapsed Spread Sheet that records and posts time...

    The first two parts are easy

    Right Click on the attached sheet to run the macro.

    Right click on the sheet name at the bottom of excel to see the code.


    Sorry I don't code for Outlook. I have no interest in that.


    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by mehmetcik; 11-24-2013 at 09:16 PM.

  3. #3
    Forum Contributor
    Join Date
    03-14-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    491

    Re: Creating a Time elapsed Spread Sheet that records and posts time...

    Thank You.

    This is what I was looking for.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 03-18-2013, 10:12 PM
  2. Replies: 2
    Last Post: 04-19-2012, 10:34 PM
  3. Using start/end time fields on userform to populate elapsed time on spreadsheet
    By Lothar69 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-11-2011, 05:07 PM
  4. Replies: 2
    Last Post: 04-27-2011, 08:21 AM
  5. Replies: 2
    Last Post: 08-26-2009, 02:56 PM

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