software

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: www.excelforum.com/member.php...oamp;userid=18851
View this thread: www.excelforum.com/showthread...hreadid=529018Try:

=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.ukquot;annepquot; gt; wrote in
message ...
gt;
gt; I am tyring to use something like
gt; A1: 08:30 AM
gt; A2: = A1 5 min
gt; copy down
gt;
gt; have to to calculate a watering schedule which I can use to recalculate
gt; Vapor Pressure Deficit using for example daylight hours. I need to be
gt; able to use this over and over again with different minutes in between.
gt; Is it possible to do that with minutes, or any suggestion about going
gt; around it?
gt;
gt;
gt; --
gt; annep
gt; ------------------------------------------------------------------------
gt; annep's Profile:
gt; www.excelforum.com/member.php...oamp;userid=18851
gt; View this thread: www.excelforum.com/showthread...hreadid=529018
gt;

Thank you, I really like your option 2 because it adjusts itself.
Anne--
annep
------------------------------------------------------------------------
annep's Profile: www.excelforum.com/member.php...oamp;userid=18851
View this thread: www.excelforum.com/showthread...hreadid=529018