1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to track employee time in excel using Macro

Discussion in 'VBA Macros' started by Akash kothari, Apr 14, 2017.

  1. Akash kothari

    Akash kothari Member

    Messages:
    66
    Hi,

    How can we track daily time of employee in excel. (Task1, Task2, Breaks, Meeting, Away from system - if system is idle for like 10 min.

    I have attached a excel file and points which mentioned I can explain, this file I got through some website.

    1) Login and Logout time - Excel should automatically start recording login and logout time as soon as employee opens this file.
    2) Activity - These are the daily activity which employees normally do in office. (Can be manually done)
    3) Project - Project on which employee is working.(Can be manually done)
    4) Start Time / End Time - Start time and End time for the task (need to automate, as soon as employee clicks on start recording button and stop recording button)
    5) Idle time - how long employee was idle on system, for each tasks (System Idle for 5 min, while working on each individual tasks). (need to automate)
    6) Total activity time - is nothing but End time - Start time. (need to automate)

    as soon as employee click on Stop timer that Task row details should get copied to 2nd tab with all the details 'weekly Production Log'.

    Thank you
    Akash

    Attached Files:

  2. vletm

    vletm Well-Known Member

    Messages:
    2,263

    Attached Files:

  3. Akash kothari

    Akash kothari Member

    Messages:
    66
    Thank you so much for your Help Vletm,
    and Sorry for delayed response,

    Do you have any suggestion How can I improve this format ?
    if you have seen any format in past ?

    Thank you
    Akash
  4. vletm

    vletm Well-Known Member

    Messages:
    2,263
    Akash kothari - how to improve ..
    1) You should know what do You want to measure?
    2) .. as well as what someone wants for report ... or just collect data?
    3) 'Idel'-time ... means extra clicks while do real work or why this?
    4) Do every employee have own 'track'-file?
    5) Using this should be much 'clear'; max two clicks per action.
    > At least those, You should figure before next steps!
    Akash kothari likes this.
  5. Akash kothari

    Akash kothari Member

    Messages:
    66
    Hi vletm,

    1) You should know what do You want to measure? - (I am looking to prepare file which track time on daily basis of every employee on different activities, so that will help us to know how much each employee utilized and who has availability)
    2) .. as well as what someone wants for report ... or just collect data?
    (This will be helpful to check utilization of employee's and availability)

    3) 'Idel'-time ... means extra clicks while do real work or why this? (By Idle time I mean if employee has not even moved a mouse for 5 min or more, or when any there are no activity/Task on which he is currently working on)

    4) Do every employee have own 'track'-file? (No, we do not have one as of now, this file should be used to understand how much time a employee spending on which activity)
    5) Using this should be much 'clear'; max two clicks per action.
    (can't we add button of start and stop for an activity - as soon as employee start task he needs to click button and when he is finished should click on stop button and activity reports total time, Idle time and mentioned task gets updated as completed).

    Thank you
    Akash
  6. vletm

    vletm Well-Known Member

    Messages:
    2,263
    Akash kothari ... hmm?
    Would You try use this?
    User can click ONLY those 'Text Boxes' as user changes task/job/duty...
    Green values shows 'working' times and red values idel times.
    Daily values will save.
    > Ideas ... Questions?
    >> Ps. This is not ready!

    Attached Files:

  7. vletm

    vletm Well-Known Member

    Messages:
    2,263
    Akash kothari
    ... next version
    Clicking 'Graph' keeps user 'Alive' = no Idel time!

    Attached Files:

    Thomas Kuriakose likes this.

Share This Page