active-technologies.com - Network Computer Services - Web Page Design and Hosting - QuickBooks & Bookkeeping Services            
  • Login

Network & Computer Services

  • Full Network - Computer Maintenance - Repair
  • Cloud - Servers - Desktops - Mobile
  • New Equipment Roll-outs
  • System Upgrade - Lifecycle Management
  • Windows - Linux - Office - LibreOffice
  • Backup Systems
  • WiFI & Barcode
  • Security - AntiVirus - Malware
  • System Design - Planning - Training
  • Purchase Equipment At Cost Through Us
  • On-site and On-line Service Service



Web Page Design & Optimization

  1. Drive Customers To Your Business
  2. Web Hosting and Maintenance
  3. Web and Mobile Web Sites
  4. Wordpress Customization
  5. Drupal CMS Customization
  6. Organic Search Engine Optimization (SEO)
  7. Local Search Engine Optimization (SEO)
  8. Website Re-Design and Intranets
  9. Online Shopping Carts & Catalogs
  10. Web Analytics and Reporting

QuickBooks & Bookkeeping Services

  • Quickbooks Online Certified
  • Quickbooks Desktop MultiUser
  • Building Construction Job Costing
  • Landscaping - Cleaning Services
  • Point of Sale and Warehousing
  • Installation Upgrades Support
  • Inventory
  • Payroll
  • Custom Reporting
  • 12+ Years Experience!

  • Home
  • About Us
  • Projects
  • Legalease
  • Green Policy
  • Recommendations
  • CIM Manufacturing Demo
  • Contact Us

You are here

Home | Excel

Services

  • What We Do
  • Web Page Design
  • Mobile Web
  • Web Hosting
  • Identity Management
  • Search Optimization
  • Content Manager
  • Computer Repair
  • Network Service
  • Backup System
  • Network Assessment
  • Disaster Recovery
  • Data Recovery
  • Technology Planning
  • Technology Partner
  • AntiVirus
  • Quickbooks

Navigation

  • Chaos Tools AJAX Demo
  • Forums
  • Recent content

Excel: Pivot Tables: Tracking Time

Submitted by gma on Tue, 10/03/2017 - 07:09

Imagine you need to log time for different clients and projects and periodically report your time by client and project. There are of course many applications dedicated to time-tracking, but you can easily create your own flexible system using Pivot Tables.

At a minimum, what you need to record is a date, the time you spent, the client name, and the project. So, after you enter the data consistently, you might end up with source data that looks something like this:

Simple time tracking data by client and project

Note that there are no blank lines - you just need to enter the data as you go.

Now the summaries. First, you might want an overview of your time by week. Here we are using the week numbers provided by Excel's WEEKNUM function (see column C of the source data):

A summary of time by week number

You might also want to arrange the pivot table to show a more traditional timesheet layout, with days of the week across the top:

A summary of time logged for one week

Each time you filter on a different week number, your pivot table will build a new time sheet that displays the dates that belong to the week.

Note that by adding a column for Name to the data, you could track and report time for multiple people. You could also add a rate column to the data and use a pivot table to summarize the cost or billing rate of time logged.

‹ Excel: Pivot Tables up Excel: Stop Excel From Turning Fractions into Dates ›
  • Printer-friendly version
  • Log in to post comments
  • 2387 reads

News

  • News

References

  • Thunderbird
  • Outlook
  • Excel
  • Word
  • Access
  • General
  • Open Source
  • Mobile
  • Security
  • ShareWare
  • Site map
  • SEO News/Tips
  • Social Media

Search form

Copyright © 2004-2021 Active Technologies, LLC
Network Computer - Web Services - Quickbooks Provider
(Powered by active-technologies.com)

Search engine optimization