Spreadsheet: 726286d1617144433-time-formatting-in-a-custom-timesheet-copy-of-2021-timesheet-template-1-check
Sheet: Monthly Timesheet

Month: |  |  | January
Year: |  |  | 2021 |  |  |  | Weekly Hours: |  | 1904-01-02 13:30:00
 |  |  | Total hours carried forward from last month |  |  |  |  |  | 1900-01-01 00:00:00
01 January 2021
Date | Day |  | Start Time | End Time | Total Break | Total Absence | Total Working Hours | Time Owed | Cumulative | Comments
01/01/2021 | Friday |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 00:00 | -07:30 | #N/A
02/01/2021 | Saturday |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 00:00 | 00:00 | #N/A |  |  | Instructions:   Enter your start and finish time to the corresponding date. Enter the total hours spent on break in "Total Break" and any annual leave, sickness or other authorized leave (NOT time owed) in "Total Leave", and state in the comments box the details.   All entries must be in form hh:[NAME].   Once month is complete, sent to Assistant Service Manager with line manager CC'd in, ensuring you read and confirm the "Declaration" below.
03/01/2021 | Sunday |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 00:00 | 00:00 | #N/A
04/01/2021 | Monday |  | 09:00:00 | 17:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 08:00 | 00:30 | #N/A
05/01/2021 | Tuesday |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 00:00 | -07:30 | #N/A
06/01/2021 | Wednesday |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 00:00 | -07:30 | #N/A
07/01/2021 | Thursday |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 00:00 | -07:30 | #N/A
08/01/2021 | Friday |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 00:00 | -07:30 | #N/A
09/01/2021 | Saturday |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 00:00 | 00:00 | #N/A
10/01/2021 | Sunday |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 00:00 | 00:00 | #N/A
11/01/2021 | Monday |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 00:00 | -07:30 | #N/A
12/01/2021 | Tuesday |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 00:00 | -07:30 | #N/A
13/01/2021 | Wednesday |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 00:00 | -07:30 | #N/A
14/01/2021 | Thursday |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 00:00 | -07:30 | #N/A
15/01/2021 | Friday |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 00:00 | -07:30 | #N/A
16/01/2021 | Saturday |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 00:00 | 00:00 | #N/A |  |  | I have read and understood the Research and Innovation Local Agreements.  In e-mailing a PDF of this timesheet to the Assistant Service Manager for authorisation at the end of each calendar month and copying in my line manager for information, I declare that: 1. The information I have provided is correct and complete and has not been claimed elsewhere.  2. I understand that if I knowingly provide false information this may result in disciplinary action and I may be liable for prosecution and civil recovery proceedings. 3. I consent to the disclosure of information to and by Dorset County Hospital and the NHS Counter Fraud Authority for the purposes of verification and the investigation, prevention, detection, and prosecution of fraud.
17/01/2021 | Sunday |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 00:00 | 00:00 | #N/A
18/01/2021 | Monday |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 00:00 | -07:30 | #N/A
19/01/2021 | Tuesday |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 00:00 | -07:30 | #N/A
20/01/2021 | Wednesday |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 00:00 | -07:30 | #N/A
21/01/2021 | Thursday |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 00:00 | -07:30 | #N/A
22/01/2021 | Friday |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 00:00 | -07:30 | #N/A
23/01/2021 | Saturday |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 00:00 | 00:00 | #N/A
24/01/2021 | Sunday |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 00:00 | 00:00 | #N/A
25/01/2021 | Monday |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 00:00 | -07:30 | #N/A
26/01/2021 | Tuesday |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 00:00 | -07:30 | #N/A
27/01/2021 | Wednesday |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 00:00 | -07:30 | #N/A
28/01/2021 | Thursday |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 00:00 | -07:30 | #N/A
29/01/2021 | Friday |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 00:00 | -07:30 | #N/A
30/01/2021 | Saturday |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 00:00 | 00:00 | #N/A
31/01/2021 | Sunday |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 00:00 | 00:00 | #N/A
 |  |  |  |  | Total hours carrying over to next month: |  |  |  | #N/A
 |  | January
 |  | February
 |  | March
 |  | April
 |  | May
 |  | June
 |  | July
 |  | August
 |  | September
 |  | October
 |  | November
 |  | December