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 |