Forum Discussion

Copper Contributor

Dec 18, 2019

adding time in excel

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?

Silver Contributor

Dec 18, 2019

Hi,

Try this simple formula:

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

Hope that helps