Forum Discussion
Timing a Small Fun Run
I know nothing, Jon Snow!
What I am after is some help with a simple spreadsheet for recording the finish times of a couple dozen runners who are partaking in a 5k run.
1. Hit a button to start them off
2. When each runner crosses the line push a lap button to record their time
3. We will then put in the time of that person manually.
So basically a stopwatch a lap function.
Anyone smarterer than me
1 Reply
Sure J-Dog
Should be pretty simple.
Column A is the runners name.
Column B is the Start time. Change the format of that column to Time.
Column C is the End time. Change the format of that column to Time also. Any time entered in the am is entered like 8:00 or 9:00. Time in the PM is entered as 14:00 (for 2:00 pm). It will convert it automatically after you enter 14:00.
Column D is a formula to calculate the total minutes between those two times.
=(c4-b4)*1440
Change the format of this column to general. That should work.
c4 and b4 represent the columns to the left. Assuming we started on the 4th row and then repeat the formula down for each runner. 1440 is the total minutes in a day.
Anyhow, you can go from there. Cheers.
