Note (8-4-2015)
I made a new version of this Excel, which can calculate total project-hours, see:
http://worktimesheet2014.blogspot.com.es/2015/04/timesheet-for-worked-hours-2015-v3-with.html
This post is about the new version (V2) of the Excel I made to track your worked hours, the "Timesheet 2015". For my post about the previous version (V1), see:
http://worktimesheet2014.blogspot.com.es/2014/01/timesheet.html
What´s new in V2:
- V2 has the calendar for 2015 and the holidays in Spain/Madrid.
- V2 is better documented, and uses cell-comments to describe the columns of the 'input-table' (where you have to enter your worked hours)
- V1 showed all columns with formulas of the input-table, V2 only shows 1 calculated column, that with the end-result of all calculations (difference between your worked hours and contract-hours, which should be 0). This to avoid the risk that you accidentily change a column with a formula.
- V1 was mainly in Spanish and had a translation-table for English, V2 is in English
- V1 had, besides de the timesheet, also a year-calendar and vacations-planner, V2 doesn´t, these documents are now in separate Excels, see:
http://worktimesheet2014.blogspot.com.es/2014/12/year-calendar-and-planner-2015-and.html
http://worktimesheet2014.blogspot.com.es/2014/07/vacations-planner-in-excel.html
- V2 has more statistics.
- V2 has an extra input-table, to book the time you worked for a project per day per office-hour
- V2 has a new office-hours/work-week table for a short workweek of 35 hours.
- V1 was free of charge and V2 isn´t.. No, I was just kidding, V2 is also for free, but if you want to make a small donation, I appreciate it. My PayPal-account is related to my hotmail-account "eigersoftware" (see also sheet-1 of the Excel of this post).
How to use this Excel:
step 0: delete all my input for this demo (green columns in sheet 'Tabla'), which has data for every (working) day in 2015 (with extra details for month decembre, that´s why I filtered the input-table for this month)
step 1: the Excel has some 'parameters' which you should check and maybe change, like e.g. the table with the office-hours, e.g.: for a 40 hour work-week. NB: you can use more then 1 workweek-table per year, e.g. in Spain during the months July and August, we have a summer-schedule of 37 hours in stead of the standard 40 hours-workweeks in the rest of the year.
step 2: fill for every day in sheet 'Tabla' (see fig.2) the green columns of the input-table, like start-time and end-time of working-day and break(s). The yelow cell 'Tdiff' shows the difference of time-worked vs time-contract (should be >= 0), in minutes. And you can also register the time you worked for a project per day per office-hour, see sheet 'DiaHoras'.
step 3: update pivot-tables in sheet 'Estadisticas' (see fig.1), click menu Analizar > Actualizar Todo (o menu Datos > Actualizar (Analyze > Refresh). For more info about pivot-tables, see:
https://www.ablebits.com/office-addins-blog/2014/11/19/excel-pivot-table-tutorial/
For more details about this Excel, see the document itself, the demo-data, especially that of december should give a good impression how to use this Excel to track your hours.
And to conclude I want to thank Excel-MVP John Walkenback for adding my blog on his website about Excel, which is a great source of information about Excel, see:
http://spreadsheetpage.com
Figures:
Fig.1: Statistics: pivot-tables and graphs to show total worked time (and difference with time-contract, so the time you should work)
Fig.2: Input-table with start-time and end-time per day (input) and total hours worked and difference with contract (calculated). Table is input for pivot-tables (see fig.1).
Fig.3: Input-table with time you worked for a project per day per office-hour
Downloads:
#Mirror 1:
https://es.scribd.com/doc/252535966/TimeSheet-to-track-worked-hours-2015
#Mirror 2 (Excel file):
NB: this site has MS Onedrive, which has 'Excel-Online', so you can view my Excel-files here if you don´t have MS Excel on your PC
http://1drv.ms/17BM33z
#Mirror 3:
http://goo.gl/OrcFbC
