View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default Time Calculation

On Sun, 3 May 2009 12:35:11 -0700, Mel wrote:

I am trying to keep race times in excell. Anyway, the question is how to
calculate race results. When I do a simple formula for subtraction,
"=A10-A9" kind of thing, the program says that the dates are not compatible.
I think the program believes my race time (in minutes) are actually dates, so
it has trouble calculating. Any ideas on how to fix this? Thanks!


Enter the times as times, and not as dates.

h:mm:ss.000

--ron