Spreadsheet: 112013d1308214355-if-formula-to-work-out-actual-time-cost-seo-work-log-and-price-list
Sheet: Work Log 

Customer | Date | Worker | Product | Time Taken | Total (excl VAT) | Invoice Number | [NAME]
 |  | Nick | Keyword Research | 45 minutes
 |  |  | Title Tag Optimization | 30 minutes
 |  |  | Setting Up Twitter | 45 minutes
 |  |  | Setting Up Facebook | 15 minutes
 |  | [NAME] | 1 x traffic building and co.uk domain | 15 minutes
 |  |  | 1 x traffic building and co.uk domain
 |  |  | 1 x text link advert for 1 year
 |  |  | Content Optimization
 |  | Mark | 1000 Backlinks
 |  |  | Online Stats Report
 |  |  | 1000 Backlinks
 |  |  | Free One Page SEO Knowledge
 |  | Vitrani | Keyword Research
 |  |  | Online Stats Report
 |  |  | [NAME]
 |  |  | 1000 Backlinks
 |  | Outsource | 1000 Backlinks
 |  | [NAME] | Free One Page SEO Knowledge
 |  |  | 1 x text link advert for 1 year
 |  |  | Robots.txt Optimization |  |  |  |  |  |  |  |  |  |  |  |  |  | Product | Price |  | Worker | Time Taken
 |  |  | Setting Up Facebook |  |  |  |  |  |  |  |  |  |  |  |  |  | 1000 Backlinks | 30 |  | Outsource | 15
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Free One Page SEO Knowledge | 10 |  | Nick | 30
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Online Stats Report | 10 |  | [NAME] | 45
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 x traffic building and co.uk domain | 44.99 |  | Mark | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 x text link advert for 1 year | 120 |  | Vitrani | 2
 |  |  |  | Total |  |  |  |  |  |  |  |  |  |  |  |  | Keyword Research | 24 |  | Belinda | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Title Tag Optimization | 24 |  | [NAME] | One Off Fee
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Robots.txt Optimization | 6 |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Working on HTML source Code | 144 |  | Sean
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Image and Hyperlink Optimization | 36
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Header Tag Optimization | 72
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Local Search Engine Submission | 144
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Content Optimization | 144
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 72
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Local Search Website Optimization | 36
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Updating Pages For Local Search | 72
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Article Writing | 72
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Press Release Writing | 250
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Setting Up Twitter | 50
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Setting Up Facebook | 75
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Setting up MySpace | 75
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Setting up Ecademy | 75
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Setting up Linked In | 75
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Social Bookmarking | 144
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Blog Submission | 72
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Press Release Submission | 72
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Article Submission | 72
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PowerPoint Presentation Submission | 144
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Video Submission | 72
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Photo Sharing | 72
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Manual Link Requests to Related Sites | 216
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 144
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Google,Yahoo & MSN Sitemap.XML Creation | 36
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Google Analytics (Statistics) | 36
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Monthly SEO Report ([NAME]) | 100
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Monthly SEO Report (Silver) | 400
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Monthly SEO Report (Gold) | 700