View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sandy Mann
 
Posts: n/a
Default 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