View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default fomula needed to find the "new" time, for example if

thanks Bob it worked great for this example, one minor issue however,
if I need to put in a different amount of time than 93, it no longer
works. The start time and the minutes will vary.any more
ideas........please


Bob Phillips wrote:
=A1+TIME(0,93,0)

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

wrote in message
oups.com...
fomula needed to find the "new" time, for example if in cell A1 I put
in the time right now of 3:19 pm, and I want to know what time it will
be in 93 minutes, is there a function that handles that? The answer
should be 4:52 pm. I could put the 93 in cell B1 and the formula
(assuming there is one) in C1. Thanks in advance for your help!