Time Sheet 1

[az4]

I work alone and have become very frustrated with my time sheet set up in excel. It is not easy to enter information or task descriptions, nor does it add up cumulative hours per project, etc. Does anyone know of a great inexpensive software for timesheets or a simple soution for excel?

 

[IRstuff]

I'm confused. If it's not adding up hours, that's a operator problem. I've never heard of Excel not adding up the numbers that you tell it to.

TTFN

 

[az4]

I stand corrected. It adds. I would like to be able to type in a job, or pick on a job and see how many hours I worked on that particular job in 2005, and know exactly what work was performed. My basic point is that I do not like my current set up and would appreciate any advice.

 

[MintJulep]

Look at the pivot table feature of Excel.

Provided that you have enter some association between a project and hours, it should do what you seem to want.

 

[IRstuff]

I agree, pivot table is what you want

TTFN

 

[sdz]

I have a spreadsheet for recording my time and then I can use it to calculate daily hours for all cost codes; all ready to be entered into the company's spreadsheet.

Extending it to handle a full year could be asking a bit much. Maybe you should be using a data base.

 

[IRstuff]

Shouldn't be a problem. You could have separate sheets for each week with details by date. The pivot table summary is by week only. Every additional week simply requires extending the pivot table by one column and you have up to 255 columns to work with

TTFN

 

[namdac]

Our time sheets are set up so that we can look-up a project number with a radio button that is linked to our main project file. But this file is locked so that only the scheduler can access it.
Regards,
Namdac

 

[zdas04]

Sounds like you will have to learn the basics of any program you use. As mentioned above this is a database problem. I build an Access database to track my hours, build invoices, and track invoices and it works perfectly. Took a couple of days to write it, but I had prior knowledge of Access. It is worth learning.

Trying to make Excel be a database requires some seriously advanced techniques that can be difficult to write, debug, or maintain. Don't try to enter a race horse in a NASCAR event, you'll end up with blood in the infield.

David

 

[DonPhillips]

I use this for my small, one-person, firm.

http://www.timewriter.com

Don Phillips

http://worthingtonengineering.com

 

[katmar]

A low priced application that seems to meet your requirements is Fanurio. I do not use the software myself, and I am not associated with the company in any way. You can download the demo and try it for free to test how suitable it is before you pay anything. See

http://www.fanuriotimetracking.com/

 

[francesca]

Sounds like you need a database, with a form to input data and a table that holds your projects and employees. You would calculate total employee hours per project using a query.

If you know your way around Access, it'll be simple to set up, and if you really know your way around Access, your entire company can use the database with set permissions -- e.g. only project managers can add jobs; employees can only add time sheets using the time sheet form (although this poses a problem with timesheet approval), only project managers can query projects, etc.

 

[DRC1]

If you have Access, they have a free templat for time billing worksheets that may solve your problem.