Spreadsheet: 155773d1337031171-punch-time-data-calculating-of-hours-worked-and-of-hours-worked-alone-per-shift-punch-time-data-example
Sheet: Example

Empl No | Last name | First name | Title | Area | Start Date | End Date | Start time | End time | HOURS WORKED | [NAME] ALONE | A/A Code | Attendance/Absence Type
1 | Doe | [NAME] | Retail-Hourly | 123 Toon Town | 2010-01-02 00:00:00 | 2010-01-02 00:00:00 | 12:00:00 | 20:15:00 |  |  | 1 | Straight Time
2 | Smith | [NAME] | [NAME] | 123 Toon Town | 2010-01-02 00:00:00 | 2010-01-02 00:00:00 | 05:00:00 | 13:00:00 |  |  | 1 | Straight Time
3 | Dane | [NAME] | Retail-Hourly | 123 Toon Town | 2010-01-02 00:00:00 | 2010-01-02 00:00:00 | 05:47:00 | 13:59:00 |  |  | 1 | Straight Time
4 | Flower | [NAME] | Retail-Hourly | 123 Toon Town | 2010-01-02 00:00:00 | 2010-01-03 00:00:00 | 21:30:00 | 05:30:00 |  |  | 1 | Straight Time
5 | [NAME] | [NAME] | Retail-Hourly | 123 Toon Town | 2010-01-02 00:00:00 | 2010-01-02 00:00:00 | 14:00:00 | 22:00:00 |  |  | 1 | Straight Time
1 | Doe | [NAME] | Retail-Hourly | 123 Toon Town | 2010-01-03 00:00:00 | 2010-01-03 00:00:00 | 14:00:00 | 22:00:00 |  |  | 1 | Straight Time
2 | Smith | [NAME] | [NAME] | 123 Toon Town | 2010-01-03 00:00:00 | 2010-01-03 00:00:00 | 05:00:00 | 14:00:00 |  |  | 1 | Straight Time
3 | Dane | [NAME] | Retail-Hourly | 123 Toon Town | 2010-01-03 00:00:00 | 2010-01-03 00:00:00 |  |  | 8 |  | 4 | Vacation
4 | Flower | [NAME] | Retail-Hourly | 123 Toon Town | 2010-01-03 00:00:00 | 2010-01-04 00:00:00 | 21:30:00 | 02:00:00 |  |  | 1 | Straight Time
5 | [NAME] | [NAME] | Retail-Hourly | 123 Toon Town | 2010-01-03 00:00:00 | 2010-01-03 00:00:00 | 13:00:00 | 21:00:00 |  |  | 1 | Straight Time
1 | Doe | [NAME] | Retail-Hourly | 123 Toon Town | 2010-01-04 00:00:00 | 2010-01-04 00:00:00 | 14:00:00 | 22:00:00 |  |  | 1 | Straight Time
6 | Wonka | Willie | Retail-Hourly | 123 Toon Town | 2010-01-04 00:00:00 | 2010-01-04 00:00:00 |  |  | 8 |  | 972 | Leave
7 | Sparrow | [NAME] | Retail-Hourly | 123 Toon Town | 2010-01-04 00:00:00 | 2010-01-04 00:00:00 |  |  | 8 |  | 972 | Leave
4 | Flower | [NAME] | Retail-Hourly | 123 Toon Town | 2010-01-04 00:00:00 | 2010-01-04 00:00:00 | 05:00:00 | 16:00:00 |  |  | 1 | Straight Time
5 | [NAME] | [NAME] | Retail-Hourly | 123 Toon Town | 2010-01-04 00:00:00 | 2010-01-04 00:00:00 | 12:56:00 | 21:04:00 |  |  | 1 | Straight Time
3 | Dane | [NAME] | Retail-Hourly | 123 Toon Town | 2010-01-04 00:00:00 | 2010-01-05 00:00:00 | 21:28:00 | 05:33:00 |  |  | 1 | Straight Time
2 | Smith | [NAME] | [NAME] | 123 Toon Town | 2010-01-04 00:00:00 | 2010-01-04 00:00:00 | 04:00:00 | 15:30:00 |  |  | 1 | Straight Time
3 | Dane | [NAME] | Retail-Hourly | 123 Toon Town | 2010-01-05 00:00:00 | 2010-01-05 00:00:00 | 14:00:00 | 22:00:00 |  |  | 1 | Straight Time
6 | Wonka | Willie | Retail-Hourly | 123 Toon Town | 2010-01-05 00:00:00 | 2010-01-05 00:00:00 |  |  | 8 |  | 972 | Leave
7 | Sparrow | [NAME] | Retail-Hourly | 123 Toon Town | 2010-01-05 00:00:00 | 2010-01-05 00:00:00 |  |  | 8 |  | 972 | Leave
1 | Doe | [NAME] | Retail-Hourly | 123 Toon Town | 2010-01-05 00:00:00 | 2010-01-05 00:00:00 | 05:00:00 | 16:00:00 |  |  | 1 | Straight Time
2 | Smith | [NAME] | [NAME] | 123 Toon Town | 2010-01-05 00:00:00 | 2010-01-05 00:00:00 | 12:58:00 | 21:04:00 |  |  | 1 | Straight Time
5 | [NAME] | Micky | Retail-Hourly | 123 Toon Town | 2010-01-05 00:00:00 | 2010-01-06 00:00:00 | 21:30:00 | 05:20:00 |  |  | 1 | Straight Time
4 | Flower | [NAME] | Retail-Hourly | 123 Toon Town | 2010-01-05 00:00:00 | 2010-01-05 00:00:00 | 05:00:00 | 14:00:00 |  |  | 1 | Straight Time