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.
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.
Now drag the formula till row 6 to accommodate all the values we have in column A
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.