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

Now look at the right end of the figure from December 11 th to the 14 th.It implies declining usage during this period. But I told you there was no usage on the 12 th and 13 th.That’s another ...