How do I add hours, minutes etc. to a time?

[jscochrum]

Hoping someone can help here, What I am trying to do is to add a time amount to a base time. Basically, I’m trying to take a departure time, add travel time, and get the arrival time. I entered in my departure time cell “11:00″ for 11 AM, and in the travel time cell “2.87″ for 2 hours and 49 minutes. I would like the sheet to add travel time to the departure time and the result be “1:49 PM” in the arrival time cell. Is this possible?

[daddylonglegs]

It's easier if you put the time to add as a time value, e.g. if A1 is 11:00 and B1 is 2:49 then you can just sum those to get 1:49 PM, i.e. in C1

=A1+B1

format C1 as h:mm AM/PM

If B1 must be in decimal format, i.e. 2.87 then you can divide that by 24 to get 2:49 so C1 should be

=A1+B1/24