View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Jim Rech
 
Posts: n/a
Default calculating time with tenths

There really shouldn't be any problem multiplying a true time entry by, say,
10% and getting the right answer. If it doesn't look right make sure the
cell has the same time format as the cell with the original time. One easy
way to do this is by using Copy followed by Edit, Paste Special, Formats.

--
Jim
"Phil Schuman" wrote in message
. com...
| We have some times from Track and Field events.
| How can I use Excel to compare times as a ratio,
| or calculate percentages of event times.
|
| ie -
| 1:04.23 compared as a ratio to 1:05.45
| or finding 10% of 1:04.23
| or finding 10% of 24.43
|
| There does not seem to be an easy way
| to manipulate time as numbers in Excel,
| especially with tenths & hundredths.
|
|