Thread: time add
View Single Post
  #1   Report Post  
Jeff
 
Posts: n/a
Default 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