Spreadsheet: 101397d1299536208-excel-function-for-calculating-hours-in-a-week-for-several-employees-productionreport
Sheet: Sheet1

New Format for your data
Client | Project | Account Manager | Staff | Time | Status | Date
RCMP | Troop 7 Top Picks and Burn Disks | Heather | [NAME] | 1 |  | 2011-05-11 00:00:00 |  |  |  |  | Sum of Time | Date
SSTC | Annual Report Financials | Jayda | Erin | 2 |  | 2011-05-11 00:00:00 |  |  |  |  | Staff | 2011-05-11 00:00:00 | 2011-05-12 00:00:00 | 2011-05-13 00:00:00 | 2011-05-14 00:00:00 | Grand Total
RCMP | Tags for photos | [NAME] | VIctor | 3 |  | 2011-05-11 00:00:00 |  |  |  |  | [NAME] |  | 1 |  |  | 1
SHCA | Golf Tourney Registration Form | Jayda | [NAME] | 2 |  | 2011-05-11 00:00:00 |  |  |  |  | [NAME] | 1 |  |  |  | 1
RCMP | Tags for Photos | [NAME] | [NAME] | 1 |  | 2011-05-11 00:00:00 |  |  |  |  | [NAME] | 3 | 4.5 | 4 |  | 11.5
RCMP | Tags for Photos | [NAME] | Justin | 1 |  | 2011-05-11 00:00:00 |  |  |  |  | Christine |  | 2 | 0.5 |  | 2.5
RCMP | Tags for Photos | [NAME] | [NAME] | 1 |  | 2011-05-11 00:00:00 |  |  |  |  | [NAME] | 3 | 1.5 | 4 | 1 | 9.5
SSTC | APM dry run | Jayda/Andrew | Justin | 2 |  | 2011-05-11 00:00:00 |  |  |  |  | Erin | 4 | 3 | 4.5 | 9 | 20.5
Fairways West | [NAME] | Jayda | Zlatan | 2 |  | 2011-05-11 00:00:00 |  |  |  |  | Heather | 2 |  |  |  | 2
[NAME] | Create Staff e-mail signatures | [NAME] | Erin | 1 |  | 2011-05-11 00:00:00 |  |  |  |  | Jayda | 1.5 | 2.5 | 0.5 | 0.5 | 5
RHA | Create Curling Ad for Web | [NAME] | [NAME] | 0.5 |  | 2011-05-11 00:00:00 |  |  |  |  | [NAME] |  | 4.5 | 0.5 |  | 5
My Ementor | Name Creative | [NAME] | [NAME] | 1 |  | 2011-05-11 00:00:00 |  |  |  |  | Justin | 3 | 7 | 7.5 |  | 17.5
HCSAS | Create 2 new certificates (phone the client) | Zlatan | Zlatan | 0.5 |  | 2011-05-11 00:00:00 |  |  |  |  | [NAME] | 2 | 3 | 3 |  | 8
Harvard Communities | Complete tradeshow booth | Zlatan | Erin | 1 |  | 2011-05-11 00:00:00 |  |  |  |  | [NAME] |  |  | 1 |  | 1
Fairways West | Design big box ad for Leader Post | Zlatan | [NAME] | 0.5 |  | 2011-05-11 00:00:00 |  |  |  |  | VIctor | 7.5 | 2 | 1 |  | 10.5
Look Matters | Web Server DRP Plan | Zlatan | Victor | 2 |  | 2011-05-11 00:00:00 |  |  |  |  | [NAME] | 1 | 7 | 2 |  | 10
Sun Dale | Website [NAME] | Zlatan | Victor | 2 |  | 2011-05-11 00:00:00 |  |  |  |  | Zlatan | 2.5 |  | 0.5 | 1 | 4
Look Matters | Unblock Zlatan's IP 64.201.213.169 | Zlatan | Victor | 0.5 |  | 2011-05-11 00:00:00 |  |  |  |  | Grand Total | 30.5 | 38 | 29 | 11.5 | 109
Rochdale Crossing | Splash Page | Jayda | [NAME] | 1 |  | 2011-05-11 00:00:00
Rochdale Crossing | Get Content Organized | Jayda | Jayda | 1.5 |  | 2011-05-11 00:00:00
Look Matters | FIX SPREADSHEET | [NAME] | Heather | 2 |  | 2011-05-11 00:00:00
MLW | Edit Top Picks | [NAME] | [NAME] | 2 | Completed | 2011-05-11 00:00:00
SHCA | Meet with [NAME] on Media [NAME] | [NAME] | [NAME] | 1 |  | 2011-05-12 00:00:00
RCMP | insert RCMP dates and change photos as requested in email | [NAME] | [NAME] | 2 |  | 2011-05-12 00:00:00
RCMP | Give frame price to [NAME] | [NAME] | Christine | 2 |  | 2011-05-12 00:00:00
RCMP | Sales book for divisions layout of design prepared | [NAME] | [NAME] | 4 |  | 2011-05-12 00:00:00
SHCA | Proofread Rate Guide Changes | Erin | Jayda | 2 |  | 2011-05-12 00:00:00
dundee | captions into ads | [NAME] | Erin | 2 |  | 2011-05-12 00:00:00
dundee | web coding start | [NAME] | Justin | 4 |  | 2011-05-12 00:00:00
dundee | rumour creative | [NAME] | [NAME] | 1.5 |  | 2011-05-12 00:00:00
sweep | commercial creative w jeremy | [NAME] | [NAME] | 1 |  | 2011-05-12 00:00:00
lux granite | finalize web copy | [NAME] | Justin | 3 |  | 2011-05-12 00:00:00
dundee | weekly lp ads | [NAME] | Erin | 0.5 |  | 2011-05-12 00:00:00
ementor | Create new logo | [NAME] | [NAME] | 1.5 |  | 2011-05-12 00:00:00
[NAME] | [NAME] w coders | [NAME] | Victor | 1 |  | 2011-05-12 00:00:00
robinson | web coder meeting for massive site | [NAME] | Victor | 1 |  | 2011-05-12 00:00:00
Fairways | Design builder and resident newsletters | zlatan | [NAME] | 3 |  | 2011-05-12 00:00:00
Fairways | Finalize radio copy | Zlatan | Jayda | 0.5 |  | 2011-05-12 00:00:00
Fairways | Finalize brochures for printing | Zlatan | Erin | 0.5 |  | 2011-05-12 00:00:00
Harvard Communities | Populate Facebook page for Harvard Communities | Zlatan | [NAME] | 2 |  | 2011-05-12 00:00:00
SHCA | Finalize Content List for eNews | [NAME] | [NAME] |  |  | 2011-05-12 00:00:00
RCMP | Troop 7 Shipping | Heather | [NAME] | 3 |  | 2011-05-12 00:00:00
Rochdale Crossing | Splash Page | Jayda | [NAME] | 1 |  | 2011-05-12 00:00:00
Realty Executive Faith Realty | Business Portrait Photography | Heather | [NAME] | 1 |  | 2011-05-12 00:00:00
Realty Executive Faith Realty | Business Portrait Editing | Heather | [NAME] | 0.5 |  | 2011-05-12 00:00:00
SHCa | Design of Media Kit | [NAME] | [NAME] | 2 |  | 2011-05-13 00:00:00
Brandt Industries | March 9th Shoot | Heather | [NAME] | 3 |  | 2011-05-13 00:00:00
H&B | Editing of video complete | [NAME] | [NAME] | 2 |  | 2011-05-13 00:00:00
RCMP | Tags for Photos | [NAME] | [NAME] | 1 |  | 2011-05-13 00:00:00
RCMP | Tags for Photos | [NAME] | Justin | 1 |  | 2011-05-13 00:00:00
RCMP | Tags for Photos | [NAME] | [NAME] | 1 |  | 2011-05-13 00:00:00
LM | [NAME] and sweaters designed | [NAME] | Christine | 0.5 |  | 2011-05-13 00:00:00
RHA | Heat map and stats pages printed for stayinregina.com | [NAME] | Victor | 1 |  | 2011-05-13 00:00:00
SSTC | Create APM Evite | Jayda | Erin | 1 |  | 2011-05-13 00:00:00
RHA | 2 experience bannerstands | Carl/Erin | Erin | 0.5 |  | 2011-05-13 00:00:00
SHCA | Rate Guide Internal Proof Changes/Ad finsalization | Erin | Erin | 2.5 |  | 2011-05-13 00:00:00
[NAME] | site map | [NAME] | [NAME] | 1 |  | 2011-05-13 00:00:00
lux granite | site sign off and launch | [NAME] | Justin | 2.5 |  | 2011-05-13 00:00:00
Fairways | Create contest materials for Spring Home Show | Zlatan | [NAME] | 2 |  | 2011-05-13 00:00:00
Fairways | Develop campaign for Greenside Terrace | Zlatan | Erin | 0.5 |  | 2011-05-13 00:00:00
Fairways | Develop campaign for Greenside Terrace | Zlatan | [NAME] | 0.5 |  | 2011-05-13 00:00:00
Fairways | Develop campaign for Greenside Terrace | Zlatan | Jayda | 0.5 |  | 2011-05-13 00:00:00
Fairways | Develop campaign for Greenside Terrace | Zlatan | Zlatan | 0.5 |  | 2011-05-13 00:00:00
[NAME] | Work on the website | Zlatan | Justin | 4 |  | 2011-05-13 00:00:00
[NAME] | [NAME] Tickets | Zlatan | [NAME] | 1 |  | 2011-05-13 00:00:00
[NAME] | Track & Trail Discount Card | Zlatan | [NAME] | 0.5 |  | 2011-05-13 00:00:00
[NAME] | Certificate | Zlatan | [NAME] | 0.5 |  | 2011-05-13 00:00:00
Brandt Industries | March 9th Shoot [NAME] | Heather | [NAME] | 1 |  | 2011-05-14 00:00:00
RHA | Source company to create branded chocolates | [NAME] | Jayda | 0.5 |  | 2011-05-14 00:00:00
SSTC | APM PowerPoint | Jayda | Erin | 2 |  | 2011-05-14 00:00:00
Fairways | Develop campaign for Greenside Terrace | Zlatan | Erin | 4 |  | 2011-05-14 00:00:00
QAM | Website Training | [NAME] | Zlatan | 1 |  | 2011-05-14 00:00:00
Allman | idty package | [NAME] | erin | 3 |  | 2011-05-14 00:00:00
Friday | Friday | Friday | Friday | Friday
H&B | Research how to photograph jewelry using a light cone and try it out | CARL | [NAME] | 1.5 |  | 2011-05-15 00:00:00
LM | install of new western sales sign | [NAME] | [NAME] |  |  | 2011-05-15 00:00:00
[NAME] | Send File to Print (Client Approval) | Christine/Erin | [NAME] | 0.5 |  | 2011-05-15 00:00:00
H+B | Sales kit update design edited with new content | [NAME] | [NAME] |  |  | 2011-05-15 00:00:00