# Employees Time Sheet Dashboard

#### dieselkhan

##### Member
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 .

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

• 47.3 KB Views: 23

#### vletm

##### Excel Ninja
dieselkhan
I made one nice example of output.
There are all INs & OUTs and Working Hours.

#### Attachments

• 66 KB Views: 37

#### dieselkhan

##### Member
i dont neeed any graph just simple dashboard

#### dieselkhan

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

I think like this .....

#### Attachments

• 19.7 KB Views: 11
Last edited:

#### vletm

##### Excel Ninja
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.

#### Attachments

• 51.6 KB Views: 18

#### dieselkhan

##### Member
thanks Vletm but my boss asked me for formulas he dont need in Pivot version

#### dieselkhan

##### Member
can you calculate on this sheet

#### Attachments

• 145.2 KB Views: 23

#### 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:

What do the 1's, 0's and 5's mean?

#### Megan Wale

##### New Member
Nice sheet but it would be great if it calculates daily and weekly employee work ours.

#### vletm

##### Excel Ninja
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...

#### Megan Wale

##### New Member
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...
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.

#### vletm

##### Excel Ninja
Megan Wale
You should open a new case,
after You'll know:
What are You looking for?

#### Megan Wale

##### New Member
Megan Wale
You should open a new case,
after You'll know:
What are You looking for?
Thank you, Sure I will try again and let you know.