I am new to the Project Management role and am looking for suggestions on how to track time based on this question: If our contract allows for X amount of hours to be included per week (not per project) and all additional hours over that week are billable, is there a system that allows for that which does not require a lot of manual intervention?
thanks for your help! Saving Changes...
Sort By:
William MellerIT Project, Program & Portfolio Manager| PolestarGothenburg, Sweden
Tess Keen,
Intersting this discussion, therefore I'm commenting to follow the community tips here.
But, for more people can help, maybe you can tell a example history of this situation in a real case. Saving Changes...
Wade HarshmanScrum Master| GDITIndianapolis, In, United States
This seems like something you could setup in Excel relatively quickly.
Column headers in row 1. Column A: Week (each row represents 1 week, with header in column A) Column B: Hours worked per week (enter number) Column C: Hours permitted (if it changes; if static, could simply define in one cell) Column D: Billable Hours (=B2-C2) or slightly more complicated (=IF(B2gtC2, B2-C2,0) Column E: Bill (D2*[cell where rate is defined])
Is that close enough, or do you need something more robust? *-'gt' meaning "greater than." This forum doesn't like that symbol, but Excel knows what it means. Saving Changes...
Was hoping for something a little more robust. After a bit more conversation with my team, the current time tracking software we have will work - it will just take a little but of manual intervention.
My experience has shown over and over again that time is most accurately accounted for if done on a daily or daily task basis. A simple web-form that collects a bare minimum of info that your stakeholders can rapidly and painlessly complete and puts it in a database (like MS-Access) will give you everything you need. A couple of simple reports should be able to give you a breakdown of time that will prevent you from leaving money on the table.
If your current time tracking software/process is not well-liked, difficult to use or only collects data at most, once a week, I guarantee dollars are being lost. Saving Changes...
