| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Quasi Transpose / Stacking Columns | Excel Worksheet Functions | |||
| How to change Series order in a Combination Chart? | Charts and Charting in Excel | |||
| series graph -- one series being added to another series | Charts and Charting in Excel | |||
| Dynamic series in Chart | Charts and Charting in Excel | |||
| How do I enter minutes and seconds (lap times)? | Excel Discussion (Misc queries) | |||
Linear Mode
