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.