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
|