2. Then right click to select Format Cells from the context menu. And in the Format Cells dialog, under Number tab, select Custom from the Category list, then type m/d/yyyy hh:mm:ss into the Type textbox. See screenshots: 3. Click OK. Then you can see each date and time cell is added one hour.What is the formula for adding hours in Excel?
In Excel, generally, you may use the formulas to add hours, minutes or seconds to the datetime cells. 1. Select the cell next to the first cell of the datetime list, and then type this formula =A2+1/24 into it, press Enter key and drag the auto fill handle over the cell needed this formula. See screenshots.How do you insert time in Excel?
On a worksheet, select the cell into which you want to insert the current date or time. Do one of the following: To insert the current date, press Ctrl+; (semi-colon). (Windows) To insert the current time, press Ctrl+Shift+; (semi-colon). (Mac) To insert the current time, press + ; (semi-colon).