Fill cells with times

[annep]

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?

[Sandy Mann]

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
>

[annep]

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