Peo,
That doesn't work.
Jeff
"Peo Sjoblom" wrote:
The TIME function will not roll over after 60 minutes but you can replace
it with
$B$1+((ROW()-1)/1440)*$B$3
now it will increment and the date will change as well
--
Regards,
Peo Sjoblom
"Jeff" wrote in message
...
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
|