How to Add Minutes to Time in Microsoft Excel

Useful for timesheets and project management tools

If you want to add minutes to a time notation in Microsoft Excel, there are several ways to do it, as long as you understand how Excel calculates time.

To add minutes to time in Excel, follow the steps outlined below.

Understanding Time in Excel

Time in Excel is represented as fractional days. For instance, an hour is 1/24 of a day, and a minute is therefore 1/1440 (since a day has 1440 minutes). You can add minutes to time by combining the original time data with the fraction that represents the minutes you want to add.

Excel translates the decimal equivalent of these fractions into easy calculations that can bemanipulated further using formulas.

Excel’s Time Format

Excel represents time using the 24-hour time format,h:mm. Every time value is a fraction of a day, with midday represented as0.5.

Serial Numbers and Time

In Excel,dates and timesare stored as serial numbers. The integer part signifies the date, while the decimal part reflects the time. For instance, 12:00 PM is0.5since it’s half a day. You’ll need to understand this when working with time, as Excel internally calculates with these numbers.

How to Add, Subtract, and Calculate Time in Excel

Working with time in Excel requires an understanding of thecumulative time value,which combines hours, minutes, and seconds. Excel treats these as parts of a day, making calculations straightforward once you get the hang of it.

Adding Minutes to Time

To add minutes to an existing time in Excel, you can use theTIMEfunctions. TIME, for instance, uses the following syntax:TIME(hour, minute, second).

If you have a time value in another cell, you can add to this using time. For instance, if the time inA1is1:00 PM, you can use the following formula to add 30 minutes to it:

=A1+TIME(0,30,0).

This is because theminutevalue is30, which TIME converts into the required decimal fraction to add to the original time in A1, returning1:30 PM.

Subtracting Time

Subtracting time in Excel provides the difference between two time values. This is much easier, as long as you have two time values to work from.

For instance, ifA1contains1:30 PM, andA2contains0:30(meaning 30 minutes), you can use the simple subtraction calculation=A2-A1to remove 30 minutes, returning1:00 PM.

You can also use TIME to do this. For instance,=A1-TIME(0,30,0)would subtract 30 minutes from the value in A1. If A1 contains1:30 PM, this would also return1:00 PM.

Calculating Elapsed Time

You might be looking to calculate the elapsed time or the difference between a start and end time. At its most basic, this is the same as subtracting one time value from another, so you can use a similar subtraction as the one shown above.

For example, if your start time is9:00 AMin cell A1 and the end time is5:30 PMin cell A2, your formula would be=A2-A1. This will give you the duration between these two times as a decimal fraction of a complete date—0.33.

You can then times that value by 24 to see the value as the total number of elapsed hours or minutes.

Related:After mastering time manipulation, why not learnhow to add and subtract dates in Excel, too?

Advanced Time Calculations in Excel

If you’re trying to manage more complex time calculations, you might need to look at more advanced Excel time calculations instead.

Handling Durations Over 24 Hours

To accurately record times that span more than 24 hours, you’ll need to adjust Excel’s time format. By default, Excel interprets time cycles every 24 hours, which can cause confusion with elapsed time.

To handle durations exceeding 24 hours, follow these steps, which will work for both Windows and Mac users.

Using Formulas for Cumulative Time

Summing up time to get a cumulative value might involve adding multiple time segments. You can easily do this using aSUMformula.

Let’s assume you have individual time values in separate cells over cellsA1toA8. You can use theSUMfunction in a formula, such as=SUM(A1:A8),to add up these time values to get the total.

If the result doesn’t format correctly, especially if the total cumulative time value is over 24 hours, change the cell number formatting using the steps in the previous section to handle longer durations.

Using a Custom Number Format in Excel

In Excel, custom number formats allow you to fine-tune how your data looks without altering the actual values. You might have start and end times within your dataset and need to format the cells to display the elapsed time precisely.

We’ve explained already how you can use a custom number format to deal with complex time values, such as those that go over the 24-hour limit. You can customize the formatting further to control and display the existing time values in a cell exactly how you need them, whether that’s in hours, minutes, or seconds.

To customize the time format for specific tasks, follow these steps.

Working Out Time in Excel

Using basic calculations or the TIME function in Excel, you can easily add minutes to existing times in your Excel spreadsheet. This will be useful for all kinds of applications, from timesheets to project management tools.

Need to quickly put the current time into your Excel spreadsheet? You canadd a timestamp in Excelusing a quick keyboard shortcut.

Ben Stockton is a freelance technology writer based in the United Kingdom. In a past life, Ben was a college lecturer in the UK, training teens and adults. Since leaving the classroom, Ben has taken his teaching experience and applied it to writing tech how-to guides and tutorials, specialising in Linux, Windows, and Android. He has a degree in History and a postgraduate qualification in Computing.Read Ben’s Full Bio

Welcome to Help Desk Geek- a blog full of tech tips from trusted tech experts. We have thousands of articles and guides to help you troubleshoot any issue. Our articles have been read over 150 million times since we launched in 2008.

HomeAbout UsEditorial StandardsContact UsTerms of Use

Copyright © 2008-2024 Help Desk Geek.com, LLC All Rights Reserved