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.
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.