• 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...

  • 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

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)
 

Attachments

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



I think like this .....
 

Attachments

Last edited:

vletm

Excel Ninja
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?
 

p45cal

Well-Known Member
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?
 
Top