如果工作表中有秒錶，您將知道完成工作的時間。 如何在具有開始，停止和重置按鈕的工作表中創建秒錶，如下面的屏幕截圖所示？ 如果單擊“開始”按鈕，它將啟動時間，如果您單擊“停止”按鈕，它將停止時間，並且“重置”按鈕可以幫助您重置時間。 本文將介紹如何在Excel中創建一個簡單且方便的秒錶。
同 Kutools for Excel's 添加時間/分鐘/秒至日期 功能，您可以快速添加或減去數小時，分鐘或秒鐘的日期。 現在點擊下載並免費試用Kutools for Excel！
Kutools for Excel：比200方便的Excel加載項，可以在60天免費試用。 下載並免費試用現在！
1。 點擊 開發人員 > 插入 > 命令按鈕，看截圖：
2。 然後拖動鼠標繪製一個按鈕，插入按鈕後，可以更改按鈕標題，請點擊 開發人員 > 屬性在 屬性 對話框中，輸入新的標題“開始“這個按鈕在文本框旁邊 標題，看截圖：
4。 插入按鈕後，應通過單擊退出設計模式 開發人員 > 設計模式.
5。 然後，右鍵單擊當前工作表選項卡，然後選擇 查看代碼，在彈出 Microsoft Visual Basic for Applications 窗口，請將以下代碼複製並粘貼到 模塊:
Public StopIt As Boolean Public ResetIt As Boolean Public LastTime Private Sub CommandButton1_Click() Dim StartTime, FinishTime, TotalTime, PauseTime StopIt = False ResetIt = False If Range("C2") = 0 Then StartTime = Timer PauseTime = 0 LastTime = 0 Else StartTime = 0 PauseTime = Timer End If StartIt: DoEvents If StopIt = True Then LastTime = TotalTime Exit Sub Else FinishTime = Timer TotalTime = FinishTime - StartTime + LastTime - PauseTime TTime = TotalTime * 100 HM = TTime Mod 100 TTime = TTime \ 100 hh = TTime \ 3600 TTime = TTime Mod 3600 MM = TTime \ 60 SS = TTime Mod 60 Range("C2").Value = Format(hh, "00") & ":" & Format(MM, "00") & ":" & Format(SS, "00") & "." & Format(HM, "00") If ResetIt = True Then Range("C2") = Format(0, "00") & ":" & Format(0, "00") & ":" & Format(0, "00") & "." & Format(0, "00") LastTime = 0 PauseTime = 0 End End If GoTo StartIt End If End Sub Private Sub CommandButton2_MouseDown(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single) StopIt = True End Sub Private Sub CommandButton3_Click() Range("C2").Value = Format(0, "00") & ":" & Format(0, "00") & ":" & Format(0, "00") & "." & Format(0, "00") LastTime = 0 ResetIt = True End Sub
注意：在上面的代碼中， C2 是秒錶時間將被插入的單元格，而 CommandButton1, CommandButton2, CommandButton3 是按鈕名稱，您可以從中查看確切的按鈕名稱 名稱框，看截圖：
6。 然後你應該格式化時間單元格 文本 格式，您可以根據需要更改單元格大小，字體，字體顏色，背景等，請參閱截圖：
7。 完成上述步驟後，從現在開始，點擊 開始 按鈕，時間將會開始，然後點擊 停止 按鈕，它會停止時間， 重啟 按鈕將重置時間，請參閱截圖：
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
To post as a guest, your comment is unpublished.· 1 months agoHI. I have created the stopwatch, but need to be able to have the various intervals between the start and stop to be saved to be able to reflect them as a time and motion study. Any tips on how to do that?
To post as a guest, your comment is unpublished.· 7 months agoThank for your tip, It was running smoothly but when I input any data in this sheet It's stopped running, We need it keep running awhile input data How we can fix this problem?
To post as a guest, your comment is unpublished.· 9 months agoHi, I'm using this stopper but quite often the numbers in the display cell ("C2") start fricking out and go off - they show minus signs, the digits are incorret and the count is lost. It usually happens after about an hour or more but sometimes even before an hour goes by. Is this a common bug? and if yes, is there a way to fix it? I did remove the .00 (i.e. the miliseconds) from the code by simply erasing the: & "." & Format(0, "00") line wherever it appears - does that have to do anything with this problem?
To post as a guest, your comment is unpublished.· 1 years agoIs there any way to have the timer reset the count to zero but still keep the timer running? Ie. When I press Reset, I don't want to have to press Start again for the time to tick up.
To post as a guest, your comment is unpublished.· 1 years agoIs it possible to automatically stop the timer when screen locks and start the timer automatically when we unlock the computer?
To post as a guest, your comment is unpublished.· 1 years agoGreat, but is it possible to run 2 clocks in the same sheet? have made a second clock with new start, stop and reset buttom, but when starting the second clock the first one stops....
To post as a guest, your comment is unpublished.
To post as a guest, your comment is unpublished.· 1 years agoIs there any way to get the timer to count up or down to a specific time? I want to keep the start, stop, and reset buttons, but I need it to count up to one minute one second only, once I press start. Or count down from one minute one second to zero (01:01). Thanks for your help!
To post as a guest, your comment is unpublished.· 1 years agoHi, Melissa,
if you need to create a countdown timer in worksheet, may may the the following article can help you!
To post as a guest, your comment is unpublished.· 1 years agohello,
I did see that article, but i need it to look exactly like the stop watch on this page, but i need it to only count down from one minute one second. I need it to show in stopwatch form, but work as a count down. Any further advice?
thank you for replying!
To post as a guest, your comment is unpublished.· 1 years agoTry XNote Stopwatch.
To post as a guest, your comment is unpublished.· 2 years agoHave tried to create the stop watch using the same codes in Forms. The timer starts perfectly fine but does not stop . Please suggest how to replicate the same in forms
To post as a guest, your comment is unpublished.· 2 years agoThis was a great help and very easy to follow the steps.
To post as a guest, your comment is unpublished.· 2 years agoThank you for this post, it was very helpful. However, is there a way to tweak the code to make it so the timer does not stop when a cell is being edited? Ideally I would like to hit "Start," make a number of changes to a range of cells on the same tab, and then hit "Stop" for the total time elapsed. Any advice on this would be greatly appreciated!