View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
pinmaster pinmaster is offline
external usenet poster
 
Posts: 347
Default add hours to time

Hi,

Try:
=A4+(A3/24)

format as [h]:mm:ss

HTH
Jean-Guy

"Danny C" wrote:

Travel 500miles (A1) 50 MPH (A2) 10 hrs travel time (A3)
Leave home at 6am (A4) - Using cell A3 (not 10 hrs), how do I calculate
arrival time? (A5)
Please include Cell Format, I can add the two but can't get passed 12:00