| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
time add
Hi,
In my worksheet, I have 2 cells (mm/dd/yyyy hh:mm format) indicating start and end day(time), and a 3rd cell indicating the interval (in minutes) in Column A. I'm trying to calculate the time using the formula "=$B$1 + TIME(0,(ROW()-1) *$B$3,0)". The problem I am having is the time is changing but the date doesn't. Any idea I can fix the problem? Jeff |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Summing Time | Excel Discussion (Misc queries) | |||
| mulitiplying time | Excel Worksheet Functions | |||
| Calculating tvl time in Excel 2000 Rev.9.2720 | Excel Worksheet Functions | |||
| Help - Information with time and date | Excel Discussion (Misc queries) | |||
| time formatting and time categorizing (vlookup or data validation) | Excel Worksheet Functions | |||
Threaded Mode
