fomula needed to find the "new" time, for example if

J

jvoortman

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!
 
B

Bob Phillips

=A1+TIME(0,93,0)

--

HTH

Bob Phillips

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

jvoortman

all the best with your soccer/football team
I pasted the formula you gave me in C1 and got a result of 1:33 which
is wrong, the correct answer should be 4:52
what am I doing wrong?
 
J

jvoortman

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
 
J

jvoortman

I chnged the 93 in your formula for a cell number and now when I change
the minutes it works like I want............THANKS FOR ALL THE HELP
FOLKS
 
J

jvoortman

I figured it out (I can't believe it either) starting with Bob's info.
Thanks to you also for responding,
 
Top