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
[email protected]
[email protected] with @tiscali.co.uk


"annep" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>