| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
add time to cells
How do I add time to cells? i.e. I have a start time 14:58 on the 17th of May
and I need to create a column with each subsequent cell containing a time 15 min later or 15 seconds later. |
|
#2
|
|||
|
|||
|
One way:
A2: =A1 + TIME(0, 15, 0) or A3: =A1 + TIME(0, 0, 15) In article , "Michael H. Cox" <Michael H. wrote: How do I add time to cells? i.e. I have a start time 14:58 on the 17th of May and I need to create a column with each subsequent cell containing a time 15 min later or 15 seconds later. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you sum a range of more than 30 cells. I get error each time I try. | Excel Worksheet Functions | |||
| subtraction with time format cells | Excel Worksheet Functions | |||
| Counting Cells with time value | Excel Discussion (Misc queries) | |||
| Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) | |||
| Combined date time cell to separate date & time components | Excel Worksheet Functions | |||
Hybrid Mode
