View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Stressed Student Stressed Student is offline
external usenet poster
 
Posts: 1
Default Posting times to an Excel spreadsheet

I am trying to post the finish times for a 5k race to an excel spreadsheet.
However, everytime the minutes are higher than 24, Excel automatically
formats it to read in military time.

For example: If I enter 24:53, Excel changes this automatically to 0:53.

This messes up the finish time is there any way to stop it from formatting
like that?