Home

Cyrille Chopelet edited this page Aug 3, 2015 · 13 revisions

xls-time-tracker

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

How to use the tracker

Quick start

  1. Download the latest release.

  2. Go to the Cfg tab to set the year and initialize the rules that apply to you.
    A basic profile

  3. Go to the Timesheet tab and enter your getting-in and getting-out times.
    You can understand that, right?

Subtleties

Pauses

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 are allowed pauses, right?

Multiple profiles

You can have several rule sets. You need to define it in the Cfg tab and then the appropriate ID in column B.

Rule sets can be radically different.

Codifying your absences

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.

Create your own codes to remember why you were absent.

:bulb: You can create your own codes (e.g. A for absent, H for holidays, S for sick, C for child day, ...).

Part-time 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).

Are you supposed to remain blocked at work all day everyday?

Wut?

Was that too fast for you? Do you need more details? Follow the links.

Contributing to the project

The construct

If you wish to fork and edit the time tracker, this utility will be your best friend.

Contributing recommendations

Some guidelines for making changes to the tracker.