×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Time Sheet

Time Sheet

Time Sheet

(OP)
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?

RE: Time Sheet

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



RE: Time Sheet

(OP)
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.

RE: Time Sheet

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.

RE: Time Sheet

I agree, pivot table is what you want

TTFN



RE: Time Sheet

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.

RE: Time Sheet

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



RE: Time Sheet

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

RE: Time Sheet

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

RE: Time Sheet

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/

RE: Time Sheet

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.

RE: Time Sheet

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources