#30 Timesheet for worked hours 2015 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