Skip to main content

Project Server Help Blog

Go Search
Project Server Help Blog
Project Server Experts Community
MSProjectExperts
Training Schedule
Contact Us
  

Project Server Help Blog > Posts > Crowdsourcing the Solution to Time Tracking
 

 MS Project and Project Server Resources

 
Crowdsourcing the Solution to Time Tracking

 

Time Tracking Stinks

 

Let's face it... nobody likes to track their time. It's not fun, it's inconvenient, and it provides very little value for most of the thousands upon thousands of people who are asked to do it every day / week / month. It's not extremely difficult or time consuming to do in most cases, but nonetheless it still stinks. Whether they are using paper-and-pencil timesheets, Project Server timesheets, or another third party timesheet tool, I bet that most people would be tickled pink to hear that they never need to perform this boring and tedious task ever again.

 

It Stinks, But We Need It

On the other hand, I doubt that anyone in our community would deny the benefits of capturing data that describes how people spend their working time. We need it to status project and operational work, we need it to justify headcounts, and we need it to bill our customers... just to name a few reasons. If captured consistently and completely, the data can be extremely valuable:

  • What if you discovered that your personnel currently spend 30% of their time on projects? What if you could increase it to 50%?
  • What if you discovered that some of your personnel are 90% billable, but others are only 20% billable?
  • What if you discovered that the average work week within your department / business unit is 65 hours? What if you discovered that it is 32 hours?

 

Let's Be Innovative!

 

Until someone in a laboratory discovers a way to tap directly into our brains and record what we are thinking and doing throughout the workday, an interim solution would be extremely helpful. This solution should address the age-old problem of time tracking... the need to capture the data to manage and improve the business, while at the same time making it effortless for the company personnel to capture. After all, if we ask our personnel to follow a process or utilize a tool that is confusing or tedious, then we will most likely end up with a garbage-in, garbage-out situation.

Many existing solutions are merely slight variations from one another; a timesheet consisting of a list of tasks or activities shown in a table or form, with daily or weekly columns for entering how much time was spent on each. A truly innovative solution would cast aside any existing time tracking paradigms... no more timesheets, no more typing work hours into a form, and no more waiting until the end of the day / week / month to capture the data.

One example is a shop floor solution in which an employee swipes their ID card when they begin working at a station or work center, then swipe again when they leave the station. A system automatically tracks the amount of time that the person spent performing that activity... no manual time entry required.

With the widespread use of mobile phones, RFID (Radio Frequency ID) tags, text messaging, social networking tools, and other emerging technologies, we should be able to invent some very interesting methods of tracking our company time.

 

Crowdsourcing the Solution

 

In an effort to crack open the time tracking problem that so many companies have, I would like to engage the community to do some brainstorming. Here are a few thought starters to get the conversation rolling:

  • What specific aspects of time tracking stink?
  • What types of working and non-working time need to be captured?
  • How accurate does the data need to be?
  • How granular does the data need to be?
  • How often does the data need to be captured?
  • How often does the data need to be submitted?
  • Is it better for people to manually enter the data into a tool?
  • Is it better for a tool to automatically ask people for the data?
  • Where should the data be captured?
  • What types of devices should people use to capture the data?
  • Should it be a stand-alone tool, or embedded within other software / tools?
  • Should the tool utilize social networking platforms?

Please leave your ideas, suggestions, and other comments here.

Thanks!

Comments

Calender and time reporting integration

I ask my team members to ensure that they mark their calender with every hour they plan to work and then modify with actual events at the end of the day. Since the calenders of all team members are accessible by all other team members, we all know what every one is doing. If the calender is completely populated with actual events then there is no need of any separate time reporting.

Has anyone else explored this solution with any greater details?
at 11/3/2009 10:33 PM

Re: Calender and time reporting integration

Interesting technique for tracking your people's work. Do you then transfer the actual work hours back to MSProject to status the project tasks?
Tony Zink at 11/3/2009 11:30 PM

Solution to time reporting

Hello,

I completely agree with you. We detected the same problem and we have created a solution. I send you the link.

With our tool, time tracking is easy, fast and flexible. We can't imagine working again without PTS.

Please, take a look and send me suggestions.
I really apreciate them.

Regards
Jose
at 11/4/2009 5:08 AM

Recording Data

At the end of the day I have found as a Project Manager that every item they work on needs a category (Value Add or NOT), work effort (hours) and a status (complete %). I receive this from my team via email - yes they guesstimate but over time it is representative of the effort applied to the project. Mapping work effort (hours) with status (% work complete) allows for me to assess any schedule variances (over-runs) quiet effectively. When compared to original estimate provided by the team - assumptions, risks and unknowns are better identified and eliminated from future projects.

In short - to answer your questions;

1. What specific aspects of time tracking stink?
Having to stand accountable and explain why things are not going to plan

2. What types of working and non-working time need to be captured?
Value Add and Non Value Add... and resolving the cause of the Non Value Add (was it bad code, bugs, lack of testing)

3. How accurate does the data need to be?
Moderately - on larger projects they are only going to be reporting on one project, just the status should be increasing.

4. How granular does the data need to be?
ID, % complete (22% ready to commence, 25% commenced, 50% midproject, 75% almost complete, 90% in testing), five words on what you did.

5. How often does the data need to be captured?
Daily

6. How often does the data need to be submitted?
Daily (or they become slack... and really make things up). Make it part of the day.

7. Is it better for people to manually enter the data into a tool?
Yes, it would be nice... but email will do.

8. Is it better for a tool to automatically ask people for the data?
Probably, after 2 years I still have to ask sometimes.


9. Where should the data be captured?
MS Project is okay, but when running dozens of small projects it becomes too difficult.

10. What types of devices should people use to capture the data?
Blood and chalk will do. I don't mind, just record it.

11. Should it be a stand-alone tool, or embedded within other software / tools?
Not real fussy.

12. Should the tool utilize social networking platforms?
Yes to assist in collabortoration
at 11/4/2009 8:23 PM

is it time tracking or brussel sprouts that stink more?

Time Tracking - everybody needs to do it, nobody wants to!  So how to get compliance?

You can see my attempt to lighten the load.  check out http://projectserverexplained.com

That said, I think a solution needs to be integrated with Twitter; as a gadget on Windows desktops; and as a Mobile phone app.  We have to get the input mechanism in front of the user.  Then you might get daily updates, I stress might.  Then at the end of the reporting period the employee will only have to go to a corporate system once with most of the data, fill in the rest and be done with it. 

Now that you have heard my point of view let me give you answers from my point of view again :) for your questions:

1. What specific aspects of time tracking stink?
tracking what we do every hour of every day as if we didn't multi-task or time-split.  This is a chore.

2. What types of working and non-working time need to be captured? This needs to be standardized by the corporation.  IMHO Project Server already has this one solved except for usability.

3. How accurate does the data need to be?
within 10% unless you are billing then it must be under 5%

4. How granular does the data need to be?
Billing: by the 15 minutes usually  Cost Center work: Started, Working on it, and Finished.  Anything more and you are kidding yourself.
 
5. How often does the data need to be captured?
Daily :(   RAM is a lot more dependable than gray matter for longterm retention of this uninteresting and detailed information.

6. How often does the data need to be submitted?
Twice if you use a billable timesheet; otherwise once one day before the PM is required to present a project status report to the sponsors.

7. Is it better for people to manually enter the data into a tool? Yes, what alternative do you propose?  PMs get too much work and salary to be responsible for molly coddling the team members.

8. Is it better for a tool to automatically ask people for the data?
NO - another automatic interruption is asking for trouble

9.Where should the data be captured?
Wherever the employee spends their on-line time.  There is no one size fits all solution with any chance of success.

10. What types of devices should people use to capture the data?
Anything that can communicate with a corporate centralized Database.

11 .Should it be a stand-alone tool, or embedded within other software / tools?
It should be a light touch experience with a simple API to embed into other apps if appropriate.

12. Should the tool utilize social networking platforms?
yes if Twitter i a social networking platform, I really consider it a micro what are you doing now tool, perfect for time tracking if you can get users to use it.  Otherwise, social networking tools are probably a bad place.  Mixing work and non work can be risky on employee privacy and moral.

Thems my thoughts.
at 11/6/2009 1:02 PM

Re: is it time tracking or brussel sprouts that stink more?

Thanks for the insight, Dave... and thanks for the interesting 'My Schedule web part on the PWA home page' trick!

I agree that time entry should be placed at everyone's fingertips... whether it be an app in their Windows taskbar, an app or mobile web page on their phone, Twitter (from virtually anywhere), or a terminal on the shop floor. Any other ideas? How about a pocketable USB timestamp device with a start / stop button?

Time tracking should definitely be a no brainer... but is there a way to make it... (*gasp*) fun???
Tony Zink at 11/6/2009 1:24 PM

Re: is it time tracking or brussel sprouts that stink more?

Making time tracking fun?  I doubt it would ever be possible to hit that bar.  I have instead always tried to make time tracking a mindless task since the preferred way for most users is to say I worked 40hrs and I worked on what you wanted me to.  And that method is 100% unacceptable to PMs and others up the food chain.

I will talk a little more about time tracking on my blog (projectserverexplained.com) since time tracking in 2007 has multiple methods to achieve the same end result.  But the WORST way to track time is to wait till the end of the week and open an empty grid and begin trying to remember what it was that you did.
at 11/9/2009 2:13 PM

Pop-up Application

Where I'm sitting right now there is a little window showing statistics on how long I've been typing and staring at the screen. Periodically it pops out into a larger window and tells me how to do various stretches.

Having a similar application which pops up a few times in the day that calmly and simply asks me to enter a couple of bits of information about what I've been doing would be a useful idea if implemented correctly. It should have an option for me to ignore or suspend it for a while and should be smart enough to pop up in the morning if I have not entered time for the previous afternoon (evening... night...).

I don't resent the exercise thing because it is helpful to me and I can put it aside when I need to - and it will come back when I'm finished. Doing the same thing for time tracking - making it super simple - would also not be resentful. Reporting time at the end of the week (or month) is painful and error prone. Would be nice if someone could fix that.
at 11/12/2009 4:27 PM

Re: Pop-up Application

My thoughts exactly, Jack. I haven't thought through the best way to implement it, but I agree that it might be effective to have a tool ping people and ask them what they are currently doing... or if they have completed anything recently. It shouldn't be difficult to check what a person should be currently doing (based on scheduled tasks), then ask "What are you doing right now? Task A, B, C, or other?" A quick click of the mouse... or quick text message response (because many people don't sit at a computer all day)... might give us a decent idea what's going on.
Tony Zink at 11/13/2009 11:18 AM

Add Comment

Spam Test

Unfortunately, spammers have made our lives a bit more annoying.
Please help us take a bite out of spam.

Before submitting a comment, please prove that you are not a spam bot
by using the buttons to enter the number shown below:



          

Items on this list require content approval. Your submission will not appear in public views until approved by someone with proper rights. More information on content approval.

Title


Body *


Commenter Name


Website URL

Type the Web address: (Click here to test)  

Type the description: 

Attachments