Home
xls-time-trackerWhen you work, you often have to spend a minimum time at work. Sometimes you have to use a badge when you get in or out of the building. That does not mean you can see the time you spent in, but your managers do.
This tool was made for people who want to keep an eye on their time, either to have the same figures as their managers or just to make sure they did not unwillingly cheat their hours.
-
Download the latest release.
-
Go to the
Cfgtab to set the year and initialize the rules that apply to you.
-
Go to the
Timesheettab and enter your getting-in and getting-out times.
The tracker only allows you to seize two in times and out times a day (the main pause is expected to be lunchtime). For additional pauses (cigarette, coffee, ...), you can seize a pause time that will be deduced from your total that day.
You can have several rule sets. You need to define it in the Cfg tab and then the appropriate ID in column B.
When you wish a day not to be tracked (e.g. because you were absent), you can leave the B column empty or enter anything but a number.
💡 You can create your own codes (e.g. A for absent, H for holidays, S for sick, C for child day, ...).
If you were present only part time a day, set the Time ratio column (e.g. column C) accordingly (e.g. if you were at work only half the day, set it to 0.5).
Was that too fast for you? Do you need more details? Follow the links.
If you wish to fork and edit the time tracker, this utility will be your best friend.
Some guidelines for making changes to the tracker.
