In this lesson, you learn how to track and manage time in Basecamp.
Tracking and managing the amount of time spent on a project is a key component of successful project management. If your company bills by the hour, it’s critical to track project time. Even if you don’t need to track time for billing purposes, knowing the amount of time your team is spending on a project is invaluable information.
Basecamp’s Max, Premium, and Plus plans all offer the ability to track time. See Lesson 1, “Getting Started with Basecamp,” for more information about Basecamp’s account plans.
It’s important to note that only people who work for your company can view or enter time in your Basecamp system. The time-tracking feature is hidden from people who work at other companies, such as clients and vendors, even if your account plan includes time tracking. People at your company, however, can enter time for anyone involved in a project, even at external companies.
Define a Strategy for Tracking Time
Before you start entering project time, you need to determine whose time you want to track. For example, if you’re a service provider and charge by the hour, you might not want to enter the time clients, partners, or vendors spend on your project, even if they have to-dos assigned to them.
Basecamp offers two ways to enter time. You can do the following:
• Enable time tracking for to-do lists and associate time entries with a to-do list item.
• Enter time independently on the Time page for a specific project.
In general, it’s a good idea to track the time your project team spends on each to-do list item and reserve independent time entries only for tasks that don’t correspond to a particular to-do.
Enabling Time Tracking for To-Do Lists
In Lesson 6, “Entering and Tracking To-Dos,” you learned how to enable time tracking when you set up your to-do lists. As a reminder, on the New To-Do List page, select the Allow Us to Track Time Spent on This To-Do List checkbox. If you didn’t enable time tracking when you first created your to-do list, you can edit it and select the Enable Time Tracking for This List checkbox.
Basecamp Add-ons Offer Additional Time-Tracking Features
If you’re looking for more sophisticated time-tracking tools, consider one of the many add-on applications that integrate with Basecamp. See Lesson 16, “Integrating Basecamp with Add-ons and Other Applications,” for more information.
To enter time for a to-do list item, follow these steps:
Figure 10.1. Click the Clock icon to enter time for a to-do list item.
Figure 10.3. You can quickly see how much time has already been logged for this to-do.
Figure 10.4. Viewing a sample time log.
Help! My Hours Don’t Match
By default, the time log shows only time entered for the last seven days. If you’ve entered time beyond a one-week period for this to-do, the hours in the green box won’t match the hours on the time log report. To fix this, click the Create a Report link to select new dates for your report. See “Creating a Time Report,” later in this lesson, for more information.
Basecamp tracks the time entry, which you can view on the Time page.
You can enter time that’s not associated with a to-do list item on the Time page. To do so, follow these steps:
Figure 10.5. The Time page as it appears before making any time entries.
Basecamp tracks the time entry, which you can view on this page.
You can view time entries for a specific project or for all projects.
To view time entries for a specific project, click the Time tab for that project. The Time page opens, shown in Figure 10.6.
Figure 10.6. View time entries for your project in one place.
This page lists all time entries by date. The To-Do icon appears before any time entries associated with a to-do item.
Analyze Your Data for Greater Insight
To sort and analyze the data on this page, you can create a report or download to Excel. See “Creating a Time Report” and “Exporting Time Entries” later in this lesson for more information.
To view time entries for all your projects, click the Time tab on the Dashboard. This version of the Time page (see Figure 10.7) displays hours by project for the last seven days.
Figure 10.7. The Time page as it appears from the Dashboard.
You can’t enter time on this page. You must open a specific project to enter associated times.
If you make a mistake when entering times, it’s easy to adjust your entries.
To edit a time entry, follow these steps:
Figure 10.8. If you make a mistake, you can revise your time entries.
Your changes appear on the Time page.
To delete a time entry, follow these steps:
Basecamp deletes your time entry and removes it from the Time page.
You can create time-tracking reports for a specific project or for all your projects.
To create a report for a specific project, follow these steps:
Figure 10.9. Create time reports filtering by date and person.
Figure 10.10. A sample Basecamp time report.
From here, you can do the following:
• Create another report by clicking the Create Another Report link.
• Return to the previous screen by clicking the Back to the Full Time Log link.
• Export this report data. See “Exporting Time Entries” later in this lesson for more information.
• Click the Print icon in the upper-right corner to print the report data. Depending on your printer’s capabilities, you can print a hard copy, send the report as a fax, or save as a PDF.
You Can’t Save Basecamp Reports
A Basecamp report is essentially a temporary view of the time entries that exist in your system at any given time. You can’t save reports in Basecamp itself, but you can save the data externally.
Create a Report with Time Entries for All Projects
If you want to create a report that includes all your Basecamp projects, click the Create a Report link that appears on the Time tab on your Basecamp Dashboard. Follow the steps in this section to create your report.
If you want to sort and analyze your data in Microsoft Excel or another data analysis tool, it’s easy to export your time entries from Basecamp. You can export your time entries to a CSV format by clicking the Export link on the Time page.
CSV
CSV is an acronym for a comma-separated values file, a computer file in which fields are separated by commas. This type of file uses the .CSV filename extension for easy identification. The CSV format is commonly used to export data from a database to a spreadsheet application.
The data that you export depends on where you are in the Basecamp system when you click the Export link. For example, you export the following:
• Time entries for all projects if you’re on the Time page you access from the Dashboard.
• Time entries for a specific project if you’re on the Time page for that particular project.
• Time entries that are part of a report if you’re on the Time page that appears after creating a report.
To export time entries, follow these steps:
Figure 10.11. Select the application in which you want to open your exported data.
If you want to open your exported Basecamp data in the same application every time, click the Do This Automatically for Files Like This from Now On checkbox.
Figure 10.12 shows a sample time entry export in Microsoft Excel. From here, you can sort, analyze, perform calculations, create charts, and so forth.
Figure 10.12. You can sort, analyze, and format Basecamp data in Microsoft Excel.
In this lesson, you learned how to track and manage time with Basecamp’s time-tracking features. Next, learn about the collaborative power of the Basecamp writeboard.