Difference between times

P

pmlsports

New Member
Joined
Oct 11, 2005
Messages
5
How do you calculate the difference between two 40 yard dash times?

Athlete A: 5.18 (seconds)
Athlete B: 4.58 (seconds)

How do I calculate this so the difference is -.2 (seconds), instead of what I've been getting -.60
 

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying
Sort by date Sort by votes
Wouldn't -.60 be correct? If they are truly 40 yard dash times that is six tenths of a second. It shouldn't be reflected as -.2. Because someone's time could easily be 4.74 seconds. That is how seconds and hundreds of seconds work.
 
Upvote 0
You must log in or register to reply here.

Similar threads

Y
  • Question
Date Time Comparison
2
Replies
14
Views
262
Phuoc
P
K
  • Question
stubborn cells REFUSE to calculate as a formula even when calculate is set to automatic...(?)
Replies
2
Views
192
Alex Blakenburg
A
R
  • Question
Calculating difference between swim times and swim standards
Replies
1
Views
360
Rodenback
R
C
  • Question
Need a formula for Business Hours Mon-Fri 8AM - 5PM between two dates and times!!
Replies
3
Views
290
etaf
etaf
D
  • Question
calculated fields instead
Replies
0
Views
110
daveyc18
D

Forum statistics

Threads
1,217,412
Messages
6,136,470
Members
450,015
Latest member
excel_beta_345User

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top