add hours to time
 

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

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

add hours to time
 

YUP, That worked, I've only spent about 3 hours on this. Formatting every
combination, that I could think of.

THANK YOU!

"pinmaster" wrote:

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

add hours to time
 

You're welcome......glad I could help and thanks for the feedback.

Regards!
Jean-Guy

"Danny C" wrote:

YUP, That worked, I've only spent about 3 hours on this. Formatting every
combination, that I could think of.

THANK YOU!

"pinmaster" wrote:

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