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.

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.

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.

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

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.

Calculating Total Minutes
Next, calculate the total hours using the MOD function. In cell D2, enter:
=MOD(C2,1440)

This gives you the remainder when total minutes are divided by 1440, representing the total minutes.
Formatting Output as Hours and Minutes













![FREE Excel Timesheet Template [DOWNLOAD]](https://i.pinimg.com/originals/9e/61/cd/9e61cde56cd533183f8296afa1cd49a3.png)





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!