How do you add five seconds to a series of times?
 

I have a column for of dates and times, I need to create a function that will
allow me to add 5 seconds to the time so I can fill down.

time and dates are kept in fractions of a day therefore to add 5 seconds
add
5/(24*60*60)
to the previous cell

"Redhead" wrote:

I have a column for of dates and times, I need to create a function that will
allow me to add 5 seconds to the time so I can fill down.