I've searched online, but I must be misunderstanding the terms.
I currently have an Excel spreadsheet that I do my weekly timesheet on. It
is simple, enter the start time and stop time, and I have a formula that
calculates the duration in hours to two decimal places. For one workday,
I'll have two start/stop combinations for before and after lunch. There
are seven lines for each day of the week, and it totals the hours. Simple
I now need to track my hours by the projects I'm working on. I will
probably leave the aforementioned spreadsheet alone, since this is my
contractor's main document to bill my client (only one client, long term
contract). As I see it, each data row will have columns for date, start
time, stop time, calculated duration, project. The project should be
selectable via drop-down from a list I'd maintain on another worksheet in
the spreadsheet. At the end of the week, I'd like the hours summarized by
project, which is what I need to report to my onsite manager.
I know I've seen something of this type before, but I don't have any
examples at my current shop. Does anyone have an example they can share,
or a link to a website that does?
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2021 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.