Time Tracking Template for Lean Six Sigma | Excel Template to Track Time

Time Tracking Template
home · products · services · search · view cart · contact

NAVIGATION

Jay Arthur
888-468-1537
303-756-9144
KnowWare International, Inc.
DBA LifeStar
2253 S. Oneida
Ste 3D
Denver, CO 80224

We work with companies
that want to fire up their profits using
Lean Six Sigma

The purpose of the Time Tracking Template is to automate the collection of data for the time between steps within a process (minutes, hours, days, etc).

To accelerate any process, you have to be able to measure and improve the key steps in that process. To simplify and automate much of this data collection, the QI Macros include a Time Tracking Template.

Time Tracking Template in the QI Macros for Excel

Since most people struggle with how to input dates and times into Excel, we've created a macro to input those for you. Just click on the cells in columns A, C and D and the template will populate the cell with the current time and date.

To use the Time Tracking Template:

Click on the cell in column A to populate the current date.
Click on the cell in column C when the process starts to populate the date and time.
Click on the cell in column D when the process stops to populate the date and time.
Populate columns B, E and F with other information about each event.
Column G is calculated as the difference between the start and stop time (columns C and D).
Column H converts column G into minutes. This conversion is usually necessary to run charts.
Select the data in column H to run a chart.
To edit dates or times in columns A, C and D, click on the cell you want to edit and make changes in Excel's formula bar window.

Other tools you might consider:

The Time Tracking template is just one of the tools included in the QI Macros for Excel SPC Software for Excel.

Download the FREE 30-day Evaluation copy of the QI Macros Excel SPC Software for Six Sigma

Download
QI Macros
30-Day Trial Now!