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
stuff.
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?
Thanks,
- Dan
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 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
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.