How do I record swimming / race times in Excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to using Excel (2004 for the Mac) to record swim times, in
minutes, seconds, and fractions of a second. The standard or custom time
formats don't seem to work well. I'd also like to add and subract these
times... how do I do this? Do I need to use macros, and if so, how (in
general) would I construct one that would do the job? I understand macros in
general, and have written a few.

Thanks,
Rick C.
 
Use a Custom format like h:mm:ss.000

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
Niek,

Thanks, your suggestion works for formatting the times. However, I still
can't figure out how to do mathematical operations (add and subtract). What
is the proper construction for a formula?

Thanks,
Rick
 
Thanks. I had seen this post. They key turned out to be that I had to format
the cell properly first, BEFORE entering the formula. Then it works.

Thanks,
Rick
 
Back
Top