Excel Daily Time Tracking: Step-by-Step Guide

Gregory Jul 09, 2026

Keeping track of daily time records is a crucial task for numerous professions, from project managers to freelancers. Microsoft Excel, with its robust features and user-friendly interface, is an excellent tool for this purpose. In this guide, we'll walk you through the process of computing daily time records in Excel, ensuring you make the most of this powerful software.

Employee Time Tracking in Excel (+ video tutorial!)
Employee Time Tracking in Excel (+ video tutorial!)

Before we dive into the details, ensure you have a basic understanding of Excel. Familiarize yourself with the ribbon (the menu at the top), the formula bar (where you input data and formulas), and the worksheet (the grid where you enter data). Let's get started!

Elapsed Time Excel
Elapsed Time Excel

Setting Up Your Workbook

First, open a new workbook in Excel. A workbook is a collection of worksheets, and you can add or remove them as needed. For daily time records, one worksheet per day is usually sufficient.

Staff Time Tracker Excel Template | Employee Attendance & Overtime Sheet
Staff Time Tracker Excel Template | Employee Attendance & Overtime Sheet

Name your worksheet something descriptive, like "Daily Time Record - [Date]". To do this, click on the worksheet tab at the bottom, then right-click and select "Rename".

Creating Your Time Record Template

Automate Tasks With Excel Macro Recorder
Automate Tasks With Excel Macro Recorder

Now, let's set up a template for your daily time record. In the first row (A1 to E1), enter the following headers:

  • Task/Activity (A1)
  • Start Time (B1)
  • End Time (C1)
  • Duration (hrs) (D1)
  • Notes (E1)

Format the "Duration (hrs)" column as time, and the "Start Time" and "End Time" columns as custom time. This will allow Excel to automatically calculate the duration between start and end times.

How to Create a Timestamp in Excel
How to Create a Timestamp in Excel

Formatting Cells as Time

To format a cell as time, select the cell, click on the "Number" group under the "Home" tab, then click on the "Time" icon. To format a cell as custom time, select the cell, right-click, select "Format Cells", then under the "Number" tab, choose "Custom", and enter the format as [h]:mm.

Using the "Duration" Formula

Daily Work Tracker Excel: Essential Functions for Better Planning
Daily Work Tracker Excel: Essential Functions for Better Planning

In cell D2, enter the following formula: "=ENDTIME() - STARTTIME()". This will automatically calculate the duration between the start and end times. Press Enter, then drag the formula down to copy it for the rest of your rows.

Entering Your Daily Time Records

Daily Work Schedule Checklist Template in Excel
Daily Work Schedule Checklist Template in Excel
How to Make an Availability Schedule in Excel (with Easy Steps) - ExcelDemy
How to Make an Availability Schedule in Excel (with Easy Steps) - ExcelDemy
the excel time and date sheet
the excel time and date sheet
Excel Data Input Brilliance - 11 Tips and Tricks
Excel Data Input Brilliance - 11 Tips and Tricks
Free Excel Leave Tracker Template (Updated for 2026)
Free Excel Leave Tracker Template (Updated for 2026)
Calender in Excel ‼️ Amazing Excel trick using data validation and conditional formatting ✅ #Excel
Calender in Excel ‼️ Amazing Excel trick using data validation and conditional formatting ✅ #Excel
Excel Task Priority Tracker Template for Project Management | Priority Matrix & To-Do List Planner
Excel Task Priority Tracker Template for Project Management | Priority Matrix & To-Do List Planner
Add Minutes to Time in Excel
Add Minutes to Time in Excel
Excel Shift Schedule Time Record Maintain in Excel  Hindi
Excel Shift Schedule Time Record Maintain in Excel Hindi
How to add time with hours/minutes/seconds increments in Excel?
How to add time with hours/minutes/seconds increments in Excel?
How to Calculate Hours Worked and Overtime Using Excel Formula - ExcelDemy
How to Calculate Hours Worked and Overtime Using Excel Formula - ExcelDemy
the 5 excel shortcuts i use in daily reporting work smarter save time more
the 5 excel shortcuts i use in daily reporting work smarter save time more
⚡ Save Time in Excel Like a Pro! | Top Excel Shortcut Keys Every Beginner Must Know 🚀
⚡ Save Time in Excel Like a Pro! | Top Excel Shortcut Keys Every Beginner Must Know 🚀
How To Make A Daily To Do List In Excel
How To Make A Daily To Do List In Excel
How to Sort by Date in Excel
How to Sort by Date in Excel
🧮 Excel Formula Simplified!
🧮 Excel Formula Simplified!
Excel Tips & Tricks
Excel Tips & Tricks
Boost Productivity With 141 Free Sheets
Boost Productivity With 141 Free Sheets
EVERYTHING about working with Dates & Time in Excel
EVERYTHING about working with Dates & Time in Excel
Creating your Employee Schedule in Excel
Creating your Employee Schedule in Excel

Now that your template is set up, you can start entering your daily time records. In each row, enter the task or activity, start time, end time, and any notes. The duration will be automatically calculated.

To add a new row, simply click below the last row and start entering your data. To delete a row, select it and press the Delete key.

Sorting and Filtering Your Data

As your data grows, you might want to sort or filter it. To sort, select any cell in your data, then click on the "Sort & Filter" button in the "Home" tab. Choose how you want to sort your data. To filter, click on the filter icon in the header of the column you want to filter.

Totaling Your Daily Hours

To find the total hours worked in a day, select the "Duration (hrs)" column, then click on the "AutoSum" button in the "Home" tab. This will add up all the hours in the column and display the total in a new cell.

And there you have it! You've successfully set up and used Excel to compute your daily time records. With practice, you'll find that Excel's features make this task not only manageable but also efficient. Happy tracking!