Tuesday, May 25, 2010

Use Google Calendar as a Timesheet

I recently joined Daugherty Business Solutions, a strategic consulting partner committed to helping clients meet unique business and technology objectives. As a software consultant working on various projects I needed to be able to track the time I spent working on client projects. I also wanted a solution that didn't require installing any special software or requiring a specific computer. After trying several different approaches a fellow colleague (Todd LeLoup) showed me his technique using Microsoft Outlook Calendar to track what he was working on. I modified his technique slightly to be "cloud friendly." This technique utilizes the free Google Calendar service, requires no additional software, works on any computer, works on any Internet enabled mobile phone, and especially works great for the WebOS Palm Pre, which is my current smart phone and the mobile platform I like to develop on.

The Approach

One of the greatest features of Google Calendar is the ability to have multiple calendar "views" associated to one account. Google calendar will then overlay each view onto a single calendar, allowing you to see the big picture. I have a view for my personal calendar items (such as reminders about dentist appointments, taking out the garbage, etc) as well as a view for Daugherty client work.


Using this approach I can keep track of all the work I do for each client separately. At the end of the week I can then total up the hours spent on each client and submit to our billing department. While on site, I can use my Palm Pre mobile phone to input work information directly into the calendar as I do the work.

How to Setup Google Calendar

The first thing you need to do is make sure you have a free Google Calendar account. To sign up go to http://calendar.google.com and follow the directions for creating a new account. Once you have an account, setting up Google Calendar to support time sheets is very simple.

On the left hand side of the main calendar view will be a section titled My calendars. Click the "Add" button to begin adding a new view.


The Create New Calendar window will display. This window allows you to assign a name and description to your view. You can name the view anything you want. Just make sure it is descriptive enough for you to identify it.


Once you have your time-sheet view created you can start adding events to it. There are several different ways to add events in Google calendar, but the simplest approach is to click the drop down arrow of the time-sheet calendar under the My calendars section and select "Create event on this calendar".


This will bring up the new event window where you can enter the information about the event. I use a naming schema for my events that make it easier for me to separate work for different clients. In the What field I use the schema <<Client Name>>: <<Work Title>> where Client Name is the name of the client I did the work for, and <<Work Title>> is the name of the work I did. Starting each event with the name of the client makes it easier to group work together. The rest of the fields are self explanatory. There are two fields to make sure you set correctly before hitting save. The Calendar field determines what view will contain the event. Make sure you are using the correct time-sheet view before hitting save. The other field to double check is the Show me as field. Make sure it is set to Available so that you won't get any reminder notifications.


Other Tips and Tricks

At the end of each week I need to calculate the total hours worked for each client to be able to bill them appropriately. My simple approach is to store the total hours worked as an All Day event on the calendar. Here is how to do it.

At the start of a day I spend a few minutes and sum up all the work I did for the previous day. For each client I add an All Day calendar event using the following naming schema: <<Client Name>>:<<Client Hours>> hrs where as before Client Name represents the client I did work for and Client Hours is the amount of time spent working for that client for that day. After totalling up the work for each client I add one more All Day event summing up the entire day's worth of work. I usually use the naming schema: ------ Total Hours: <<Total Hours>> hrs ------


The All Day trick makes it extremely easy for me to create my end-of-week time sheet since All I have to do is scan the top section of the calendar for each day and plug in the numbers.

In summary, Google Calendar offers a quick, easy, portable, and best of all free solution for implementing a way to track the type of work you do. Give it a try and see for yourself!


Unknown said...

I do something similar, but I take it one step further and use Google Calendar Sync so that I can enter my time in either Outlook or Google Calendar. Click here: http://www.google.com/support/calendar/bin/answer.py?hl=en&answer=98563

Jason Fayling said...

I recently got an email from http://www.gtimereport.com/ They offer the ability to export your google calendar to excel. It looks promising. I recommend you check it out!

Randy L. Smith said...

GTimeReport is the bomb! Just discovered it, works like a charm! Keep separate calendars for each client (if you've only got a few) and it will do the work for you, plus you have detail to boot!

Unknown said...

checkout blackrabbit.org

There are trackers which allow you track your time and create Google Calendar events out of them. During tracking your time you just need to enter a description text. Afterwords you drag'n drop a single word of that text onto a symbol representing your Google Calendar. That assigns all records containing the same word to that calendar. Finally you can create Google Calendar events out of the data and get an Excel timesheet.

Unknown said...

You guys have done such an awesome job! I”m glad I found this software very helpful.

Ru said...

Yay for GTimeReport!

Unknown said...

Would it be possible for someone to write a lab/addon/app/something (or only Google?) to add a dropdown with a list of projects in the event create view to assign a calendar entry directly to a project to simplify timesheets as opposed to the current method of counting time spend on it? This way you simply fill in your calendar as always for meetings, preparation time etc. but directly assign the time for the timesheet.

RecursiveMind said...

Have you tried Gcal2Excel (www.gcal2excel.com)? It can also generate timesheets from Google calendar.

Unknown said...

Check out https://www.timetag.it - we've been using it already for sevaral years,
it allows you to log your time in Google calendar using #hashtags to identify different projects. In the Timetag web app you can manage projects, access detailed reports or generate timesheets. Ideal for individuals or small teams!
@Paul there is also a Google calendar widget available showing your project list for easy calendar entry creation !

Unknown said...

Monthly Timesheet Template When the payroll and/or billing cycle is monthly, you need a monthly timesheet to record such data. During that period of time, you can record detailed data about tasks completed in a project. Information which is important when it comes to billing your clients, paying employee salaries, managing costs, tracking projects and estimating completion times, and other tasks integral to business operations. Azor offers professionally designed monthly timesheet templates that may not only solve your time management problems. But with a little adaptation of such a template to suit the way work is done at your workplace, you will be able to bring in more productivity to the workplace.

Unknown said...

converse outlet
fitflop shoes
cheap nfl
michael kors outlet
gucci belt
coach factory store
celine outlet
kids north face
gucci outlet online
canada goose clearance
michael kors sale
north face jackets clearance
coach factory outlet online
vans shoes
coach purses outlet online
kids north face jackets
burberry sale
the north face sale
kevin durant shoes
air jordan 6
jordan 6
michael kors outlet
canada goose discount
fitflop shoes
michael kors bags
fitflops clearance
michael kors handbags
fitflops sale
nike running
coach outlets
michael kors cheap
michael kors factory outlet
retro 11
prada outlet
the north face clearance

Unknown said...

tod's shoes
hollister outlet store
abercrombie and fitch outlet
ugg boots sale
girl jordans
coach factory outlet online
under armour clearance
coach outlet
air max 2015
michael kors outlet
michael kors outlet 75% off
nike outlet
jordan 11
dior outlet store
fitflop sale
new balance outlet
jordan shoes for kids
nike outlet store online
ferragamo shoes outlet
hermes outlet
nike shoes outlet
coach outlet store online
fitflop sale
michael kors purses
new balance outlet
juicy couture
mont blanc
oakley sunglasses outlet
clarks outlet
jordan shoes
abercrombie and fitch outlet
abercrombie and fitch
michael kors outlet
air jordan 13
kobes shoes
hermes birkin
coach clearance

Online Timesheet said...

such a nice piece, thanks

Post a Comment