## Stopwatch timing

### Stopwatch timing

I'm doing some calculations for average game times for pinball machines I'll be playing in a few months by using my phone's built in stopwatch (as part of the clock application), and I'd like to create a formula that allows me to calculate total time and average time. Is this possible, and if it is, what formula should I use?
LibreOffice V3.4.5 with Windows Vista SP1
ndiniz2012

Posts: 5
Joined: Mon Feb 06, 2012 12:21 am

### Re: Stopwatch timing

You'll need to consider what information you need to store to achieve your goal. What is meant by "total time"?

If you mean elapsed time for one game, then you'll need to store start and finish times and subtract start from finish. Supposing your start time is in A2 and finish time is in B2, then in C2 simply =B2-A2 would give you the elapsed time.

If you have a column, say C with a number of elapsed times, you could use the AVERAGE function to get an average. This is all fairly basic stuff.

If you are new to spreadsheets, you may find the following to be useful resources.

[Tutorial] Ten concepts that every Calc user should know

OpenOffice Spreadsheet Tutorial for Beginners with Examples
Cheers
David
Apache OpenOffice 420m2(Build:9821) - Slackware 14.2 - 64 bit
LibreOffice 6.0.7.3 - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine

robleyd
Moderator

Posts: 3099
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

### Re: Stopwatch timing

Total time is the time taken to complete a whole game of pinball, including extra balls. I have made a custom format available with hundredths of a second capability.

By the way, I do believe I have more than one account, and the email address I currently use is no longer in operation. I cannot change my nathandiniz AT comcast dot net email address to my main email address, or an alternate one.

 Edit: Email address munged so you don't invite spam; I have sent a PM about the email change [robleyd, Mod]
LibreOffice V3.4.5 with Windows Vista SP1
ndiniz2012

Posts: 5
Joined: Mon Feb 06, 2012 12:21 am

### Re: Stopwatch timing

Hi,
lets say you have your stopped periods in cells A2:A40
then you can use:
Code: Select all   Expand viewCollapse view
`=AVERAGE(A2:A40)`

and
Code: Select all   Expand viewCollapse view
`=SUM(A2:A40)`

R
MMove 1.0.6
• Extension for easy, exact positioning of shapes, pictures, controls, frames ...
my current system
• Windows 10 AOO, LOLinux Mint AOO, LO
F3K Total
Volunteer

Posts: 949
Joined: Fri Dec 16, 2011 8:20 pm