I just came out of my „Excel factory” where I have been working on a simple time tracking model. Since not all companies have implemented a system based on retina scan or an access card to get information on time spent at work, I made a simple model in Excel, which is an easier way for tracking work hours.
A simple table
Before I give you the link for download, just let me tell you how I created this model. So the first thing, I started with a simple table where I`ve enter information about employees presence.
Convert hours of time in total
In column H I wanted a numerical value for the time. In order to obtain the number of hours, I didn`t simply fell G-F but I applied the following formula:
=G*24-F*24
Company`s Dashboard
To make data analysis easier, I made a Pivot Table where we have an overview on the information related to work hours.
Employees’ Dashboard
I made also a short dashboard for each employee, see bellow.
Just a model
Perhaps in your company there are some features that would make using this example quite hard. That’s ok because I made this model to illustrate a principle, it should be changed and adapted.
Download
Yes, let’s not forget about the download link I promised.
Hope this was helpful, if so, share it with someone. Got any questions, let’s talk in the comments section.