Re: Does anyone use an Excel-based timekeeping system?

More | Report Post

On 12/20/06, M'sta Mikey wrote:
> On 12/19/06, Rich from PA wrote:
>> I have a solo practice and keep paper time records. I
>> would like to automate my timekeeping, but the commercial
>> products that I've tested are all overkill for my needs.
>>
>> Does anyone use or know of an Excel solution that has easy-
>> to-use "start time" and "end time" functions with the
>> ability to enter free-text descriptions of the services
>> rendered?
>>
>> Thanks,
>> Rich
>
> Rich,
>
> I'm not an attorney but an IT professional and programmer so
> pardon me for posting here. You can get several books on
> Excel on how to create the necessary forms/formulas that you
> need; it's really a lot easier than you think.
>
> Cell A1 has the start time in the hh:mm:ss AM/PM format
> Cell B1 has the end time in the same format as above
> Cell C1 has the formula =B1-A1 this give you the total hours
> You can then do summary calculations by the day/month for a
> client, etc. then print and send as an invoice, or create a
> custom invoice.
>
> Hope this helps.

Mikey, thank you. This is helpful. I've been trying to avoid
spending the time to learn something that I'll only use once,
but that might be the best choice in the end so that I get
what I really want. One more question: Is there a better way
to enter free-text comments other than starting a cell with an
apostrophe(')?

Thanks again.

Rich