TIMEVALUE function in Excel

There are multiple ways you can do calculations on time in Excel.

TIMEVALUE is one of the formulas you can use to do addition or subtractions to time.

For example, if you would like to add a minute to 13:00:00 (1PM), you can simply use TIMEVALUE function.

=A1+TIMEVALUE("00:01:00")

Similarly, you can do subtraction to the time with minutes, hours, or seconds.