timesheetLike most of us working on different Projects keeping and recording associated  time for each is quite a hassle.  Making it easier is always a priority.

Recently I went through the AppStore thinking it may be quite easy to enter and manage it from a tablet.  Though most are visually quite appealing they almost all fail when one want to edit time records, add additional properties or even report slightly different to what the App allows.

This led me back to faithful pivots with simple time-entries in Excel.  Herewith sanitised version I use myself, just remember to refresh Pivot for latest views.

Instructions for Use:

  1. Create Projects for which Time must be recorded. Optionally add RateCard and Client info
  2. Add Timeentries in worksheet TimeEntries
  3. Use Pivot for reporting – remember to refresh when new data was added