Adding time to a formula

Question

Hi everyone, I am having a little problem with adding time to an Excel formula

This is what I am trying to do:- cell C1 = I enter todays date and time. The formula in Cell B2 is =IF(C1="","",C1)

How do I add to the formula in cell B2 so that it will add an extra 2 minutes to the result ?

Hope that makes sense.

Rebecca

Answer 1

Use the TIME function to add 2 minutes to the value in C1.

In cell B2, use:

=IF(C1="","",C1+TIME(0,2,0))

This keeps B2 blank if C1 is blank; otherwise it returns the date/time in C1 plus 2 minutes.

---

References:

• Add or subtract time in Excel
• Insert the current date and time in a cell