Spreadsheet: 120086d1314969769-excel-2007-formula-to-find-a-letter-then-add-a-value-example-of-problem-formula
Sheet: Sept 2011

RECORD OF WORKING TIME
W = Working Time,  S = [NAME],  AL = Annual Leave,  PH = Public Holiday, FM = Force Majeure, C = Compassionate, M = Maternity, P = Parental, CA = [NAME]'s,  AD=Adoptive, [NAME]=Jury Duty, ES=Examination/Study
Note:  hours worked are recorded as hours, all other leave is recorded as a portion of a day, i.e. 1 = full day, 0.5=half day, etc
 |  | Employee 01 | Part-time | Employee 02 | full time | Employee 03 | full time | Employee 4 | full time | Employee 05 | full time | Employee 06 | full time
Th | 2011-09-01 00:00:00 | W | 7.5 | W | 4 | W | 7.5 | W | 7.5 | W | 7.5 | W | 7.5
 |  |  |  | AL | 0.5
F | 2011-09-02 00:00:00 | W | 6.25 | W | 8 | W | 7.5 | W | 3.5 | W | 5 | W | 0
 |  |  |  |  |  |  |  | AL | 0.5 | S | 0.25 | S | 1
S | 2011-09-03 00:00:00
S | 2011-09-04 00:00:00
M | 2011-09-05 00:00:00 | W | 7.25 | W | 8 | W | 7.5 | W | 7.5 | W | 7.5 | W | 7.5
T | 2011-09-06 00:00:00 | W | 0 | W | 8 | W | 7.5 | W | 7.5 | W | 7.5 | W | 7.5
W | 2011-09-07 00:00:00 | W | 0 | W | 8 | W | 7.5 | W | 7.5 | W | 0 | W | 7.5
 |  |  |  |  |  |  |  |  |  | S | 1
Th | 2011-09-08 00:00:00 | W | 8.25 | W | 8 | W | 7.5 | W | 7.5 | W | 7.5 | W | 7.5
F | 2011-09-09 00:00:00 | W | 0 | W | 8 | W | 0 | W | 3.5 | W | 7.5 | W | 7.5
 |  |  |  |  |  | AL | 1 | AL | 0.5
S | 2011-09-10 00:00:00
S | 2011-09-11 00:00:00
M | 2011-09-12 00:00:00
 |  | PH | 1 | PH | 1 | PH | 1 | PH | 1 | PH | 1 | PH | 1
T | 2011-09-13 00:00:00 | W | 0 | W | 8 | W | 0 | W | 0 | W | 7.5 | W | 7.5
 |  |  |  |  |  | AL | 1 | S | 1
W | 2011-09-14 00:00:00 | W | 0 | W | 8 | W | 0 | W | 0 | W | 2.5 | W | 7.5
 |  |  |  |  |  | AL | 1 | S | 1 | FM | 1
Th | 2011-09-15 00:00:00 | W | 7.5 | W | 8 | W | 0 | W | 7.5 | W | 0 | W | 7.5
 |  |  |  |  |  | AL | 1 |  |  | FM | 1
F | 2011-09-16 00:00:00 | W | 0 | W | 8 | W | 0 | W | 3 | W | 7.5 | W | 7.5
 |  |  |  |  |  | AL | 1 | S | 0.5
S | 2011-09-17 00:00:00
S | 2011-09-18 00:00:00
M | 2011-09-19 00:00:00 | W | 0 | W | 8 | W | 7.5 | W | 7.5 | W | 7.5 | W | 7.5
 |  | S | 1
Th | 2011-09-20 00:00:00 | W | 0 | W | 8 | W | 7.5 | W | 7.5 | W | 7.5 | W | 7.5
 |  | S | 1
W | 2011-09-21 00:00:00 | W | 7.5 | W | 8 | W | 0 | W | 7.5 | W | 7.5 | W | 7.5
 |  |  |  |  |  | M | 1
Th | 2011-09-22 00:00:00 | W | 7.5 | W | 8 | W | 0 | W | 7.5 | W | 7.5 | W | 7.5
 |  |  |  |  |  | M | 1
F | 2011-09-23 00:00:00 | W | 0 | W | 8 | W | 0 | W | 7.5 | W | 7.5 | W | 7.5
 |  | C | 1 |  |  | M | 1
S | 2011-09-24 00:00:00
S | 2011-09-25 00:00:00
M | 2011-09-26 00:00:00 | W | 0 | W | 8 | W | 0 | W | 8 | W | 7.5 | W | 0
 |  | C | 1 |  |  | M | 1 |  |  |  |  | [NAME] | 1
Th | 2011-09-27 00:00:00 | W | 7.5 | W | 8 | W | 0 | W | 8 | W | 7.5 | W | 0
 |  |  |  |  |  | M | 1 |  |  |  |  | [NAME] | 1
W | 2011-09-28 00:00:00 | W | 4 | W | 8 | W | 0 | W | 8 | W | 7.5 | W | 0
 |  | C | 0.5 |  |  | M | 1 |  |  |  |  | [NAME] | 1
Th | 2011-09-29 00:00:00 | W | 0 | W | 8 | W | 0 | W | 8 | W | 7.5 | W | 0
 |  |  |  |  |  | M | 1 |  |  |  |  | [NAME] | 1
F | 2011-09-30 00:00:00 | W | 0 | W | 8 | W | 0 | W | 7.5 | W | 7.5 | W | 0
 |  |  |  |  |  | M | 1 |  |  |  |  | [NAME] | 1
TOTALS:
Hours worked (hrs)
[NAME] (days)
Annual Leave (days)
Public Holidays (days)
Force Majeure Leave (days)
Compassionate Leave (days)
Maternity Leave (days)
Parental Leave (days)
Carer's Leave (days)
[NAME] (days)
Jury Duty (days)
Exam/Study Leave (days)