Time function - Add seconds and milliseconds to a time in another cell

[W1nn1e]

I have a cell formatted as hh:mm:ss.000

In the next cell I want to use the TIME function to increase the cell by a set number of seconds and milliseconds.

Example 00:00:01.288 in cell A1
Add 00:00:02.500 to the entry in cell A1 and display it in cell B1


I can only seem to get it work with seconds in the TIME function, as it doesn't seem to accept the milliseconds.
My TIME function is =(A1+TIME(0,0,2.500)

Is there another function to do this, or do I need to enter it in a different way? I think TIME only works to hours, minutes, and seconds.

 

[FormR]

Add 00:00:02.500 to the entry in cell A1 and display it in cell B1

Hi, welcome to the forum! How about simply:

Excel 2013/2016
	A	B
1	00:00:01.288	00:00:03.788
Sheet1

Cell Formulas
Range	Formula
B1	=A1+"00:00:02.500"

 

[W1nn1e]

Thanks for the reply and welcome message, and how easy was that - loving this forum already.

Thanks for your help FormR!