Fill cells with times
 

I am tyring to use something like
A1: 08:30 AM
A2: = A1 + 5 min
copy down

have to to calculate a watering schedule which I can use to recalculate
Vapor Pressure Deficit using for example daylight hours. I need to be
able to use this over and over again with different minutes in between.
Is it possible to do that with minutes, or any suggestion about going
around it?


--
annep
------------------------------------------------------------------------
annep's Profile: http://www.excelforum.com/member.php...o&userid=18851
View this thread: http://www.excelforum.com/showthread...hreadid=529018

Fill cells with times
 

Try:

=A1+TIME(0,5,0)

or if you wish to change the number of minutes frequently try:

=A1+TIME(0,$C$1,0)

with the number of minutes in C1

--
HTH

Sandy

with @tiscali.co.uk


"annep" wrote in
message ...

I am tyring to use something like
A1: 08:30 AM
A2: = A1 + 5 min
copy down

have to to calculate a watering schedule which I can use to recalculate
Vapor Pressure Deficit using for example daylight hours. I need to be
able to use this over and over again with different minutes in between.
Is it possible to do that with minutes, or any suggestion about going
around it?


--
annep
------------------------------------------------------------------------
annep's Profile:
http://www.excelforum.com/member.php...o&userid=18851
View this thread: http://www.excelforum.com/showthread...hreadid=529018

Fill cells with times
 

Thank you, I really like your option 2 because it adjusts itself.
Anne


--
annep
------------------------------------------------------------------------
annep's Profile: http://www.excelforum.com/member.php...o&userid=18851
View this thread: http://www.excelforum.com/showthread...hreadid=529018