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.

Employees Time Sheet Dashboard

Discussion in 'Excel Dashboards' started by dieselkhan, May 7, 2018.

  1. dieselkhan

    dieselkhan Member

    Messages:
    302
    I have employee time sheet where i need to create a nice dashboard where my boss analysis the timing and how many times employee went in and out in during working hours.


    Working hours are 8 Am to 5 PM with 1 hour lunch break.


    most of employee didn't check out at 17:00 so count their last check in or check out timing.

    who check out after 17:00 count as Over time separate timing.


    Weekly working hours are 48 .

    Please help me out in this


    Check in column and Check out Column

    if their 1 i suppose its they checked in or check out (Not Sure as this data given by Device so there is no columns names)

    Attached Files:

  2. vletm

    vletm Excel Ninja

    Messages:
    4,129
    dieselkhan
    Please, try to check what Your data shows ..
    I made one nice example of output.
    There are all INs & OUTs and Working Hours.

    Attached Files:

    Thomas Kuriakose likes this.
  3. dieselkhan

    dieselkhan Member

    Messages:
    302
    i dont neeed any graph just simple dashboard
  4. dieselkhan

    dieselkhan Member

    Messages:
    302
    should b 1st (check in )work start time and (very last )work end time each day
    nothing else



    I think like this .....

    Attached Files:

    Last edited: May 7, 2018
  5. vletm

    vletm Excel Ninja

    Messages:
    4,129
    dieselkhan
    should b 1st (check in )work start time and (very last )work end time each day
    nothing else

    I left there ID too, if no need then delete it away.

    Attached Files:

    Thomas Kuriakose likes this.
  6. dieselkhan

    dieselkhan Member

    Messages:
    302
    thanks Vletm but my boss asked me for formulas he dont need in Pivot version
  7. dieselkhan

    dieselkhan Member

    Messages:
    302
    can you calculate on this sheet

    Attached Files:

  8. vletm

    vletm Excel Ninja

    Messages:
    4,129
    dieselkhan
    I (dieselkhan) don't neeed...
    a) should b 1st (check in )work start time and (very last )work end time each day nothing else
    ...and I did as You thought in #4Reply

    where my (dieselkhan) boss analysis ...
    b) the timing and how many times employee went in and out in during working hours.
    Do You or Your boss have same goal?
    What values would Your boss would like to get to that the latest version that Your boss would analysis ... as You have written?
    ... one cell per day to analysis from THREE values?
  9. p45cal

    p45cal Well-Known Member

    Messages:
    1,231
    Can you tell us the significance of the numbers in the Check In and Check Out columns? This is one ID, one day:
    upload_2018-5-12_12-5-10.png
    What do the 1's, 0's and 5's mean?
  10. Megan Wale

    Megan Wale New Member

    Messages:
    4
    Nice sheet but it would be great if it calculates daily and weekly employee work ours.
  11. vletm

    vletm Excel Ninja

    Messages:
    4,129
  12. Megan Wale

    Megan Wale New Member

    Messages:
    4
    The above one which is attached.
  13. vletm

    vletm Excel Ninja

    Messages:
    4,129
    Megan Wale
    Okay...
    that's possible too as soon as someone would write
    a) when IN and when OUT
    b) how to handle cases eg IN - IN ...
    and so on...
  14. Megan Wale

    Megan Wale New Member

    Messages:
    4
    Thanks, actually after downloading sheet I've tried myself but didn't find what i was looking for. If possible can I get a demo video.
  15. vletm

    vletm Excel Ninja

    Messages:
    4,129
    Megan Wale
    You should open a new case,
    after You'll know:
    What are You looking for?
  16. Megan Wale

    Megan Wale New Member

    Messages:
    4
    Thank you, Sure I will try again and let you know.

Share This Page