Excel Formula: Total Hours & Minutes

Gregory Jul 09, 2026

Ever found yourself manually calculating total hours and minutes from a list of start and end times in Excel? It's a tedious task, but what if you could automate it with a simple formula? Let's dive into how you can achieve this with Excel's powerful functions.

How to Calculate Hours Worked Minus Lunch Using Excel Formulas (4 Methods) - ExcelDemy
How to Calculate Hours Worked Minus Lunch Using Excel Formulas (4 Methods) - ExcelDemy

Before we begin, ensure your start and end times are in a suitable format, such as "hh:mm" or "hh:mm:ss". If not, you might need to convert them first. Now, let's explore how to calculate total hours and minutes.

Top 21 Excel Formulas
Top 21 Excel Formulas

Using SUM and MOD Functions

The SUM and MOD functions are your key allies in this task. SUM adds up the values, while MOD returns the remainder of a division operation, helping us separate hours and minutes.

Time Sheet Calculator in Excel
Time Sheet Calculator in Excel

Here's a step-by-step guide to using these functions:

Calculating Total Hours

ms excel formula
ms excel formula

First, calculate the total minutes using the SUM function. Assume your start times are in cells A2:A100 and end times in B2:B100. In cell C2, enter:

=SUM((B2:A2)*1440)

This multiplies each duration (end time - start time) by 1440 (minutes in a day) and sums them up.

How to Convert Hours into Minutes | convert hours into minutes in Excel | Excel Tutorials |Excel2022
How to Convert Hours into Minutes | convert hours into minutes in Excel | Excel Tutorials |Excel2022

Calculating Total Minutes

Next, calculate the total hours using the MOD function. In cell D2, enter:

=MOD(C2,1440)

a notebook with microsoft excel written on it
a notebook with microsoft excel written on it

This gives you the remainder when total minutes are divided by 1440, representing the total minutes.

Formatting Output as Hours and Minutes

Excel Formulas: Basic to Advanced
Excel Formulas: Basic to Advanced
the excel time and date sheet
the excel time and date sheet
Employee Time Tracking in Excel (+ video tutorial!)
Employee Time Tracking in Excel (+ video tutorial!)
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 Between Two Times in Excel (6 Methods) - ExcelDemy
How to Calculate Hours Between Two Times in Excel (6 Methods) - ExcelDemy
Exel Formulas
Exel Formulas
how to calculate hours worked
how to calculate hours worked
the top 2 excel formulas are shown in this poster, and it is also available for
the top 2 excel formulas are shown in this poster, and it is also available for
the excel shortcuts and important formulas are displayed in this green poster, which includes
the excel shortcuts and important formulas are displayed in this green poster, which includes
the top 20 new excel formulas are displayed in this screenshoter's image
the top 20 new excel formulas are displayed in this screenshoter's image
3 Crazy Microsoft Excel Formulas That Are Extremely Useful
3 Crazy Microsoft Excel Formulas That Are Extremely Useful
107K views · 1.5K reactions | Calculating Worked Hours Using Formula!! #Excel | Excelling At Excel
107K views · 1.5K reactions | Calculating Worked Hours Using Formula!! #Excel | Excelling At Excel
Some excel important formula........
Some excel important formula........
FREE Excel Timesheet Template [DOWNLOAD]
FREE Excel Timesheet Template [DOWNLOAD]
How to Calculate Over Time in Excel 🔥#excel #shortsvideo #exceltips #tipsntricks #exceltutorial
How to Calculate Over Time in Excel 🔥#excel #shortsvideo #exceltips #tipsntricks #exceltutorial
How to Calculate Time in Excel / Add Time, Subtract Time Excel - Tutorial ⏰
How to Calculate Time in Excel / Add Time, Subtract Time Excel - Tutorial ⏰
How to Calculate Hours Worked and Overtime Using Excel Formula - ExcelDemy
How to Calculate Hours Worked and Overtime Using Excel Formula - ExcelDemy
how to create a sum formula in excel and wordpress - infographical poster
how to create a sum formula in excel and wordpress - infographical poster
the basic formula for excel formats
the basic formula for excel formats

Now that you have total hours and minutes, let's format the output as "hh:mm".

In cell E2, enter:

=TEXT(D2,"[h]:mm")

This uses the TEXT function to format the total minutes as hours and minutes.

With these steps, you can efficiently calculate total hours and minutes from a list of start and end times in Excel. This not only saves time but also reduces human error. So, the next time you're faced with a similar task, you know exactly what to do!