We help IT Professionals succeed at work.

Track the Time Spent on a Project

Gaston Mbey
Gaston Mbey asked
on
Medium Priority
140 Views
Last Modified: 2019-08-05
Hello Experts

I need a template preferably in Excel or an Online Tool where i can track the time i am spending on Projects .

I Guest consultants are using such tools

Rgds
Comment
Watch Question

Didier VxSystems Engineer and Finance Analyst
CERTIFIED EXPERT

Commented:
Hello,

What you can do is search for templates containing "Project" from Excel search tool (Professional category).
Bill PrewTest your restores, not your backups...
CERTIFIED EXPERT
Expert of the Year 2019
Top Expert 2016

Commented:
There are a lot of these already available on the interwebs, try a search like:

excel consulting time tracking - Google Search

That being said, it really depends a bit on your needs and situation.  There will be different approaches that fit better or worse depending on your needs.  Things to consider as you try and select a best fit for you might be:

  • Do you need to track multiple customers
  • Do you need to track multiple projects
  • Do you need to track tasks within projects
  • Do you want to track just time, or money as well
  • If tracking money, then is your rate fixed across all activities, or does it vary by customer / project / task
  • Do you need / want to generate status reports from it
  • Do you need / want to generate invoices from it
  • Etc...

Once you have a decent list of what you need take a look at the ones available and find a good match.  It would be hard for me to suggest one for you without knowing your situation better.  I use a relatively simple format, but I doubt my needs are exactly the same as yours.


»bp
Gaston MbeyIT CONSULTANT

Author

Commented:
Hello Bill

My Need are very simple

yes i need to track multiple projects and Mutiple Customers

I need to track just time

Billing is not my concerned
Test your restores, not your backups...
CERTIFIED EXPERT
Expert of the Year 2019
Top Expert 2016
Commented:
Well, based on that, here's a simple starting point you could consider.  The first sheet you can just add rows to as you perform chunks of work on a project.  Then you can use a pivot table as in the second sheet to view and summarize that info any way you want.

EE29154027.xlsx


»bp
Gaston MbeyIT CONSULTANT

Author

Commented:
Thx