Forum Discussion

gmj12345's avatar
gmj12345
Iron Contributor
Feb 20, 2024
Solved

Formula for adding time

How to make an addition of time in Excel minutes and hours I believe hours are easy because you just need to sum all the numbers but how about minutes I want to track my time if I have already 8 hour...
  • gmj12345 

    u have two options for adding time in Excel, depending on whether you want to:

    1. Add multiple existing times:

    In this case, you can simply use the SUM function. Excel treats times as fractions of a day, so adding them together will automatically combine hours and minutes.

    For example, let's say you have the following times in cells A1 and A2:

    • A1: 8:30 AM
    • A2: 7:15 AM

    To find the total time, enter the following formula in cell A3:

    Excel
    =SUM(A1, A2)
     

    This will display the result as 15:45, which is the sum of the two times.

    2. Add a specific duration to a time:

    If you want to add a specific duration (e.g., 30 minutes, 1 hour) to an existing time, you can use the TIME function along with addition.

    For example, let's say you have a start time in cell B1 (e.g., 9:00 AM) and want to calculate the end time after adding 1 hour and 30 minutes. You can use the following formula in cell B2:

    Excel
    =B1 + TIME(1, 30, 0)
     

    This formula breaks down the additional duration into hours (1), minutes (30), and seconds (0) and adds it to the start time in cell B1. The result will be displayed as 10:30 AM.

    Additional tip:

    • To ensure your cells display the total time correctly, even if it exceeds 24 hours, format the cells as [h]:mm:ss. This will display the time in hours, minutes, and seconds format.

    By using these methods, you can easily add time in Excel and track your work hours effectively.

Resources