Enter 12 PM, the first value in the series, into I2. Enter the formula =H3+TIME(1,15,30) in I3. Copy that formula down as far as you like. To see the seconds, apply the long time format (Figure D).