add hours to time

[Guest]

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

 

[Guest]

Hi,

Try:
=A4+(A3/24)

format as [h]:mm:ss

HTH
Jean-Guy

 

[Guest]

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

THANK YOU!

Hi,

Try:
=A4+(A3/24)

format as [h]:mm:ss

HTH
Jean-Guy

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

 

[Guest]

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

Regards!
Jean-Guy

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

THANK YOU!

Hi,

Try:
=A4+(A3/24)

format as [h]:mm:ss

HTH
Jean-Guy

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