Add Time To A DateTime Value In Excel

In his post we will see how to add time to an existing date time value in excel, below data has date time values in excel column A in which we want to add 6 minutes to each of the date time values in column A.

Excel showing date time values in which we need to add time

As you can see in the data that column B has new date time values that are incremented by 6 minutes, we will use a formula in excel called Time(hour, minute, second) which adds or subtract time value from a date time value.

We can specify hour, minute or second to existing date time value.




Enter the formula in cell B2 =A2+TIME(0,6,0) where A2 is the date time value in which we want to add 6 minutes.

excel formula to add hour/minute/second to excel

Now drag the formula till row 6 to accommodate all the values we have in column A

minute is added to the date time value in excel

You can provide negative prefix “-“ in the hour, minute or second argument in the TIME formula to subtract time value from date time value.

Hope this helped.




Share The Knowledge

Random Posts

  • Vlookup First Word In Excel

    In this post we will see how could we vlookup for first word in a string, here string could be […]

    Share The Knowledge
  • Hour From A Time In Excel

    Let’s see how to get the hour from time in excel. Hour () formula in excel returns a number from […]

    Share The Knowledge
  • Extract Name From Email Address In Excel

    Let’s see how to extract the name from the email addresses given. Generally the email addresses are of the form […]

    Share The Knowledge
  • Sort By Multiple Columns In Excel

    Let’s see how we can sort by multiple columns in excel. We will see a quick example to understand how […]

    Share The Knowledge