Solo Tip Tuesday: Use Excel Spreadsheet with Formulas to Compute Time

by Reba Nance on February 12, 2013

It’s a good practice to have your staff keep track of the number of hours they work each day. Even if you don’t have staff, you may need to track the hours that you spend working. While it can be a challenge to remember to write down when you arrive, take lunch and then leave for the day — the biggest obstacle is then adding all that together.

We’ve provided an excel spreadsheet for your use. It covers each month for 2013 and has built-in formulas built allowing you to track your hours. Enter the time you start working each day, a lunch break, and the time you stop working. In additions, there are columns that let you to keep track of the hours you spend working in the evenings. The spreadsheet automatically computes the total time so you can easily see how much time you (or your staff) is in the office each week and the grand total for the month. Also, you can track of vacation and sick time.

A few tips to keep in mind when you use the spreadsheet:

  • Enter your name in the appropriate cell at the top of each month.
  • When you hover your mouse over a cell, you will see time-entering hints.
  • If you enter any time that has a 00 in it (i.e., 8:00 a.m.), you only need to enter the number and either an a or a p. For example, 5:00 p.m. is entered as 5 p.
  • For time with a value other than 00 after the colon, you need to enter the entire number followed by an a or a p. For example, enter 5:30 p.m. as 5:30 p.

No one likes to keep track of their time. But this self-computing spreadsheet makes it a lot easier!

You can see this tip and others, on topics ranging from Outlook and Word help to App reviews and online tools, all here.

Longtime readers of the Colorado Bar Association’s C-Brief, its weekly eNewsletter, know each week there is a tip from Law Practice Management Director Reba Nance. Those tips are moving beyond the newsletter and now have a permanent home within the Practice Management section of CBA’s website. We’ll share some of the best tips each week here as Solo Tip Tuesday.

Comments on this entry are closed.

Previous post:

Next post: