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

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!