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?


Marcelo wrote:
hi,

try


=TIME(ROUNDDOWN((B1/60),0),MOD(B1,60),0)

hth
regards from Brazil
Marcelo


" escreveu:

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!