adding time in excel

[bkmendo]

I would like cell A1 to display 8 a.m.  I would like cell A2 to equal cell A1 plus 6 hours.  This should display 2 p.m. How do I do this?

[#2]

@bkmendo

Hi,

Try this simple formula:

=TIME(HOUR(A1)+6,MINUTE(A1),SECOND(A1))

 

Hope that helps

[#3]

@bkmendo 

As variant

=A1+6/24