Thread: need a formula to fix time
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme Bernard Liengme is offline
external usenet poster
  
Posts: 4,393
Default need a formula to fix time
Put this in B1
=IF(LEFT(A1)=":",TIME(0,MID(A1,2,2),MID(A1,5,2)),A 1)
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Rpt_Me4NotBeingSmart" wrote
in message ...
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