Excel examples for your work, sports and more.: Timesheet

#1 Timesheet hours worked 2014 in Excel

NB 13/1/2015:
I made a new version (V2) of this Excel, "Timesheet 2015", see:
http://worktimesheet2014.blogspot.com.es/2015/01/timesheet-for-worked-hours-2015.html

In this article I´ll explain an Excel-document (xlsx, version 2010) I made: "Time sheet hours worked 2014", which has the following functionality:

registrate your worked hours, vacations and other non-working days (e.g. sick leave)
calculate statistics like total hours worked per week, month and year, and differences with standard working times (as defined by the company)
calender with holidays (see also my other post: http://worktimesheet2014.blogspot.com.es/2014/10/calendar-2014-october-in-excel.html )
vacation planner for members of team (see also my other post: http://worktimesheet2014.blogspot.com.es/2014/07/vacations-planner-in-excel.html )

At the end of this article you can find the websites where you can download the Excel-doc. (for free).
Mirror #1, Microsoft Skydrive has "Excel Web App", so you can look the Excel-doc even in you don´t have Excel installed on your PC.

NB:
- the Excel is in Spanish, but on sheet-2 you can see a translation in English of the most used Spanish terms.
- I filled for all days of the year the worked hours, so this is how the Excel could look like at 31-12-2014.

The Excel has 5 work-sheets:

* SHEET 1

In fig.1 you can see all the dates of 2014 (white) and input-columns (green) and calculated columns (yellow). In the green cells you register every day the begin- and end-time of your work-day and the same for your breaks.

fig.1

* SHEET 2
Explication of columns in sheet-1 and vocabulary, and used formulas.

* SHEET 3

In fig.2 you can see some of the statistics, which are pivot-tables using the data in sheet-1. So every time you change data in sheet-1, you have to update these pivot-tables. In Excel 2010 (Spanish), you can do this in menu "Data > Actualizar Todo". For details, see:

http://office.microsoft.com/en-us/excel-help/refresh-pivottable-data-HA101906071.aspx

The blue bars in the graphic (in fig.2) show the total time worked in a week or month, and the red bars show the difference with the standard work hours (as defined by the company).