View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Christopher Glaeser Christopher Glaeser is offline
external usenet poster
 
Posts: 4
Default arithmetic on minutes and seconds without leading zero

I have a track and field worksheet and want to do arithmetic on sprint times
expressed as mm:ss or mm:ss.0. I can get it to work if I enter the times as
0:mm:ss, but entering the leading zero is tedious. Is it possible to enter
the times as mm:ss without the leading zero and get it to work as desired?

Best,
Christopher