Quick way to add minutes to time in excel using a simple formula

Steps to Add Minutes to Time in Excel

Follow these steps to quickly add minutes to a given time:

Step 1: Enter the Data

• In Cell A1, enter the starting time: 8:00 AM
• In Cell B1, enter the minutes to add: 12

Step 2: Use the Formula

In Cell C1, enter the following formula:

=A1 + TIME(0, B1, 0)

Step 3: Press Enter and Format the Cell

• Press Enter, and you will see the result as 8:12 AM
• If the result does not appear correctly, format Cell C1 as Time:
  • Select Cell C1
  • Go to Home > Number Format
  • Choose Time

Now, your Excel sheet will accurately calculate the updated time! 🚀

Example:-