To add 10 minutes to a date/time value in Microsoft Excel, use the following formula:
Code:
= A1 + TIME(0,10,0)
In this formula,
A1 is the cell containing the original date/time value that you want to add 10 minutes to. The
TIME function takes three arguments: hours, minutes, and seconds. In this case, we want to add 10 minutes, so we use 0 hours,
10 minutes, and 0 seconds.
Here are the steps to follow:
- Select the cell where you want to display the result.
- Type the equal sign (=) to start the formula.
- Click on the cell containing the original date/time value.
- Type a plus sign (+) to indicate that you want to add something to the original value.
- Type the TIME function with the arguments (0,10,0) to add 10 minutes.
- Press Enter to complete the formula.
The result should be the original date/time value plus 10 minutes.