how to work out 15% of swimming times in minutes seconds and 100t.

  • Thread starter Thread starter busymum
  • Start date Start date
B

busymum

can anyone please tell me how to convert a swimming time in minutes seconds
and 100th of seconds to 15% less?
 
Assuming you have the time inputted as a value (not text) you can just
multiply by 0.85 (either in a formula, or using copy - paste special,
multiply.

If you have the time inputted as text, it would be most helpful if you could
post an example of exactly how it looks.
 
you mean as decimals 2.5 represent 2 hours 30 minutes

To convert this to 15% less

--Type 0.85 in a cell
--Copy this cell
--Keeping the copy select the cells with the time value to be converted.
--PasteSpecial>Multiply>OK

If you want to convert this to excel time..Divide the numbers by 1440 and
format that to excel date time..

If this post helps click Yes
 
Hi,

I'm assuming these are properly formatted times. I use the custom format
mm:ss.000

so with a time in a1 use

=A1*0.85

and copy the formatting from the original cell

If you want to overwrite the original times put 0.85 in a cell and copy it.
Select your time(s) and then Edit|Paste special - Select Multiply OK

Mike

Mike
 
Back
Top