Formatting the cells for displaying the current time Formula: To do this, we need to press Ctrl+1, choose “Custom” category and enter the format of the time – h:mm:ss AM/PM.įigure 3. Before applying the formula, we must set the format of the resulting cell as a time. In our example, we want to display the current time in the cell B3 in format h:mm:ss AM/PM. Data that we will use in the current time displaying Displaying the Current Time In column B, we want to get a current time, while in column C we have a format of the appropriate time.įigure 2. Our table consists of 2 columns: “Current Time” (column B) and “Format ” (column C).
Setting up Our Data for Displaying the Current Time To get only the time we will need to format the cell accordingly. The NOW function has no parameters and returns the current time and date.
This step by step tutorial will assist all levels of Excel users in calculating a time difference in different formats.įigure 1. Excel can display the current time using the NOW function.
0 kommentar(er)
