Thread
:
Fill cells with times
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Sandy Mann
Posts: n/a
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
Reply With Quote