How to set the time in Excel and automatically display the change by minute and second

It can't be done with the setup method. However, it can be implemented using VBA macros**.

Implementation: Open Excel.

, press alt+f11", open the vb machine, and double-click the ThisWOOIKBOOK at the bottom", paste the following VBA into the box under General on the right, and then select Run - Run Subprocess User Form in the Takesheet column. In this case, the time:hour::) can be displayed in the A1 cell of any **

Minutes: seconds. public sub mymacro()

dtime = now + timevalue("00:00:01")

dtime, "", ,true

with range("a1")

value = now

numberformat = "hh:mm:ss"

end with

end sub

private sub workbook_open()mymacro

end sub

In our daily use of excel, we often encounter hours, minutes and seconds, how to set the time format to minutes and seconds, let me bring you the method of excel to set the time format to minutes and seconds.

Excel format time to minutes and seconds steps:1First select the cells that need to enter time, as shown in the following figure:

2Right-click the selected cell and select Format Cell.

3. In the dialog box, open the "Set Cell Format" and click "Self-Mu Shirt Definition" in the "Set Cell Format" dialog box, as shown in the following figure

4. Delete the content in the text box below "Type", as shown in the following figure

5Enter 00":"00":" in the text box below Type and click OK.

Note: The quotation marks here must be entered under the English State Input Method.

6. Enter the time in the selected cell, if you need to enter the time "15:14:36", only enter the beam car "151436" in the unit, as shown in the following figure:

1.Excel how to format time.

2.Excel method of setting the ** time format.

3.excel how to format date yyyy-mm-dd4How to set the Excel number date format.

1. Open Excel, and then enter the date and time in the cell, accurate to the second.

2. When it is not the active cell, the seconds in the date and time disappear.

3. To display the year, month, day, hour, minute, and second, it must be used'Format cells'in the customization.

4. Find the one inside'yyyy/m/d h:mm'At this time, this is also the form in the type box above.

5. Then add the content in the box of this type':ss', the colon is in English, and then click OK.

6. The seconds after the original date and time are displayed.

Let's briefly share with you the operation steps.

Computer: MacBook Air

System: macOS12

Software: 1. First of all, we open the computer, enter excel**, and click on the time cell.

2. Then we click [Custom] in the upper right corner and select [Other Number Formats].

3. Then we click to select [yyyy m d h:mm], add [:ss] seconds unit at the end, and click [OK].

4. In this way, the time in the unit of [seconds] will be displayed.

Because the cell has a time set, you can cancel it.

1. Open Excel** on the computer.

2. Select the cell of time, then right-click and select Format Cell.

3. After entering the cell settings page, click to enter the custom pants to calm down the evil.

4. After Hu Buku enters the custom page, you can see that the current cell format is mm:ss:0, if you can delete it, you can delete the format.

5. If you can't delete it, you can choose the format.

6. Once it's set, it won't become time.

Here's how to do it:

1. In the first step, open the excel sheet you want to operate, enter the formula =if(and(a1="b1="88") in the source and target cells, and then press the enter key to confirm, see the figure below and go to the steps below.

2. In the second step, after completing the above steps, you can find that A1 and B1 are empty, and the target cell is displayed as empty, see the figure below, go to the steps below.

3. In the third step, after performing the above operations, enter any text in A1 or B1, and you will find that the target cell C1 has Lu Shu Xun showing the content that needs to be displayed "88", see the figure below. In this way, the function is successfully implemented.

Select this column - right-click Cell Settings - Number - Custom - Type Input: yyyy-mm-dd hh:mm:ss - OK.

Cell--Right-click---Cell formatting--Custom--Select yyyy m d h:mm to see if it's what you want? Customization can be changed, if not, to the format you want.

Select the corresponding column.

Set Format, Number, Classify, Custom, Type.

yyyy"years"m"month"d"day" [$804]aaaa hh:mm:ss;@

OK

1.After entering the content in the content field, quickly go to the corresponding cell in column A to enter the corresponding time, here of course we are not entering it manually, use the combination shortcut keys of excel, press Ctrl+Shift+: on the keyboard

You can press Ctrl+Shift and then press the : key to enter the time.

2.If you want to display the format of hours: minutes: seconds, just select column A data, CTRL+1, and select the corresponding time format under the number.

3.How to record the date and time at the same time, and how to deal with it. In fact, excel also has corresponding shortcut keys.

4.The method of entering the date is similar to the time, but it is simpler, just press the Ctrl+: key combination.

5.In CTRL+1, go in and customize the format of the cell: yyyy:mm:dd hh:mm:ss

6.To complete the operation, record the content, select the corresponding column A cell, press Ctrl+: shortcut - Space bar -Ctrl+Shift+: shortcut key to finish.

7.I've been testing it for a few more times, and it's completely OK.

I don't know what time the current time is, the year, the month and the day?

b2=if(a1="","",today()) to bring date + time,Just change it,b2=if(a1="","",now())

Enter =now() in the excel cell and the year, month, day and time will appear.