Thread: need a formula to fix time
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rpt_Me4NotBeingSmart Rpt_Me4NotBeingSmart is offline
external usenet poster
  
Posts: 5
Default need a formula to fix time
Lets say I have time in cell A1 that displays as :59:02. How can I write an
If formula to say If A1 contains :xx:xx, then insert a zero at the
beginning, otherwise do nothing?

Reply With QuoteReply With Quote