Closed Thread
Results 1 to 2 of 2

Time Tracker - I need a macro that calculates the time spent on an activity

  1. #1
    Registered User
    Join Date
    07-01-2011
    Location
    Pune, India
    MS-Off Ver
    Excel 2003
    Posts
    5

    Time Tracker - I need a macro that calculates the time spent on an activity

    Hi,

    Can anyone help me with a macro that calculates the time spent on an activity? I have attached a spread sheet. If i choose training, then the start time should automatically populate. Then when i choose the second activity, it means that my training is over and i have moved on to the next activity. So it should populate the end time for training and the start time for the second activity (meeting in the spread sheet). Please help
    Attached Files Attached Files

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Time Tracker - I need a macro that calculates the time spent on an activity

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

Closed Thread

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