Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Subtracting time in excel to show in minutes:seconds
Hi,
I'm using the following code for a timer(stopwatch)in excel, but the final time i want to show in mintues and seconds. Is there a way do this? Does anyone have something like this already they can share with me? What I want is to have a spreadsheet to show the time it took to perform a task, but I'm trying to put a stopwatch(timer) on so its all on one sheet. Please help! Thanks, Gabe Here's what I have for a timer(stopwatch): Option Explicit Private startTime As Single Private Sub StartButton_Click() startTime = Timer End Sub Private Sub StopButton_Click() Dim finalTime As Single finalTime = Timer - startTime ActiveCell = Format(finalTime, "0:00") End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Subtracting time in excel to show in minutes:seconds
hi,
the hours and minutes seems like a simple formate problem. the timer, don't know. see this site. it is all about time. http://www.mvps.org/dmcritchie/excel/datetime.htm -----Original Message----- Hi, I'm using the following code for a timer(stopwatch)in excel, but the final time i want to show in mintues and seconds. Is there a way do this? Does anyone have something like this already they can share with me? What I want is to have a spreadsheet to show the time it took to perform a task, but I'm trying to put a stopwatch(timer) on so its all on one sheet. Please help! Thanks, Gabe Here's what I have for a timer(stopwatch): Option Explicit Private startTime As Single Private Sub StartButton_Click() startTime = Timer End Sub Private Sub StopButton_Click() Dim finalTime As Single finalTime = Timer - startTime ActiveCell = Format(finalTime, "0:00") End Sub . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I show amount of time in minutes and seconds? | Excel Worksheet Functions | |||
How do I change a minutes and seconds as a 2400 time to seconds? | Excel Worksheet Functions | |||
Display hours, minutes, seconds on a time-scale axis in Excel 2003 | Charts and Charting in Excel | |||
Time inputted as minutes and seconds Excel | New Users to Excel | |||
Convert "Time Interval" in "hours : minutes : seconds" to seconds | New Users to Excel |