Stopwatch timing

Discuss the spreadsheet application

Stopwatch timing

Postby ndiniz2012 » Sun Jul 14, 2019 7:54 am

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

Postby robleyd » Sun Jul 14, 2019 9:30 am

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
User avatar
robleyd
Moderator
 
Posts: 3018
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Stopwatch timing

Postby ndiniz2012 » Sun Jul 14, 2019 9:35 am

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

Postby F3K Total » Sun Jul 14, 2019 9:40 am

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 7 OOo, AOO, LOLinux Mint OOo, AOO, LO
F3K Total
Volunteer
 
Posts: 934
Joined: Fri Dec 16, 2011 8:20 pm


Return to Calc

Who is online

Users browsing this forum: No registered users and 34 guests