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

More | Report Post

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.