I understand i would need a Macro to imbed a 'button' into a sheet.
how would i go about setting up said button to act as a 'start/stop' button for a timer? also, how would i even creat the timer itself?
For example: i would like to push the button at the top of the sheet to start the timer, deal with what i had to do.. then push the button again to stop the timer.
[Solved] Push Button Timer
-
- Posts: 2
- Joined: Thu Sep 09, 2010 12:32 am
[Solved] Push Button Timer
Last edited by kendall_borg on Thu Sep 09, 2010 4:36 am, edited 1 time in total.
Office 3.2.1
Windows 7 x64
Windows 7 x64
Re: Push Button Timer
There are plenty of macros which put a time stamp into some cell.
Create a push button which can be toggled on/off
Put a time stamp in one cell when the button is on (pushed) and another time stamp into another cell when the button is off.
A third cel with formula =Cell2-Cell1 formatted as [HH]:MM:SS gives.00 the time between the two stamps.
Create a push button which can be toggled on/off
Put a time stamp in one cell when the button is on (pushed) and another time stamp into another cell when the button is off.
A third cel with formula =Cell2-Cell1 formatted as [HH]:MM:SS gives.00 the time between the two stamps.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
- Charlie Young
- Volunteer
- Posts: 1559
- Joined: Fri May 14, 2010 1:07 am
Re: Push Button Timer
kendall_borg wrote:I understand i would need a Macro to imbed a 'button' into a sheet.
how would i go about setting up said button to act as a 'start/stop' button for a timer? also, how would i even creat the timer itself?
For example: i would like to push the button at the top of the sheet to start the timer, deal with what i had to do.. then push the button again to stop the timer.
You asked for it. The attached file does what you want and more.
- Attachments
-
- Stopwatch.ods
- Clock/Stopwatch
- (81.22 KiB) Downloaded 1061 times
Apache OpenOffice 4.1.1
Windows XP
Windows XP
-
- Posts: 2
- Joined: Thu Sep 09, 2010 12:32 am
Re: Push Button Timer
Thanks Villeroy... DUH, dont know why i didnt think about having time stamps... I was just trying to make things WAY too complicated.
Office 3.2.1
Windows 7 x64
Windows 7 x64