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 thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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 [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.