View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
wenz324 wenz324 is offline
external usenet poster
 
Posts: 1
Default how do I get excel to add,then average numbers with two decimals?

ie I need to tally little athletics results. I need the average of the best
three scores.
These are times (minutes, seconds and hundredths of seconds) and I now
realise we probably should have been entering using colons throughout the
season. I'm trying to fix the problem without having to manually change the
results into times.

3.06.51
3.11.43
3.22.56
3.23.94
3.56.29