View Single Post
  #1   Report Post  
Lady Luck
 
Posts: n/a
Default Avoid user having to enter 00 hours when using [mm]:ss format

I am formatting a game sheet for sports events. Time should be entered as
mm:ss which I have "custom" fomatted as [mm]:ss. However I cannot find a way
to force Excel to read an entry such as 07:28 as 7 minutes and 28 seconds. It
always assumes the user is entering hours and minutes.
Thanks for any help
SBB