Timey Wimey Time Tracker with billable hours

Explore

An easy time tracker with a lot of features.

ā€‹

POPULATING THE TIME TRACKER

  1. Export your Google or Outlook calendar to a CSV format. There are several tools thatā€™ll export a time-delimited calendar (GCal2Excel, CalendarLabs, CalendarHelp, GTimeReport).
  2. Import your CSV file to this Airtable base.
  3. The time fields will probably appear as "pasted fields." Change them, or move the information, so that you have a ā€œstart timeā€ and ā€œend timeā€ fields, formatted to the minute. (In this base, I've done that.)
  4. Add fields that categorize work time in any way that works for you. (I've put in some.)

ā€‹

Use Airtable views to categorize types of work you're doing, break effort into pieces of work for a particular project, view work by type of effort, summarize how much time you spent on each piece of workā€¦what you will. I've included a couple of views that you can play with.

ā€‹

USING THE TIME TRACKER
This time tracker is really easy to use.

Enter your data in the "Notetaking" view. Keep the Time Tracker open in your browser.

ā€‹

  1. Every time you finish working on something, simply go into Notetaking. Double-click "Today" in the ā€œend timeā€ field and it will put in the exact time you finished.
  2. Then note the type of work you're starting and double-click "Today" in the ā€œstart timeā€ field.

ā€‹

BILLING

The "Total billable" field in the Time table will track total billable hours against a project. Obviously there's lots more you can do with billing, project owners, and projects.

ā€‹

GETTING SNARKY WITH TIME TRACKING
You can track not only time, but utility.

The "Full grid" view contains fields for "Impact" and "Effort." Each can be H, M, or L. (So, for instance, High impact, Low effort, is low-hanging fruit.) If you choose, you can enter values for impact and effort. The base will look on the Value table and come up with a calculated value for that work.

ā€‹

Dare we say itā€¦is there some stuff not worth doing?

Explore
Updated April 18, 2019 at 4:27 PM
Copied 354 times

Sarah Smith

Writer; hybrid-publishing my own and others' work. Rabid fan of making data lovely.
Explore the base
Notetaking grid
Sorted by effort type
Billable hours for April
View for pasting CSV info into Airtable
Full grid
Grid view
Grid view
Grid view
Grid view