View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Stefi Stefi is offline
external usenet poster
 
Posts: 2,646
Default formatting cells for time

Custom format:
mm:ss.00

Regards,
Stefi

€˛Terrie€¯ ezt Ć*rta:

I need to format cells to enter time in minutes, seconds and hundredths of
seconds. eg 2:45:89 (2 mins, 45 seconds and 89/100) How do I do it?