View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
soundengineer
 
Posts: n/a
Default turn a colon into a period? timestamp related


I have a timestamp in excel that is in the format of
Hrs:Min:sec*:*milliseconds
I need it to be
Hrs:min:seconds*.*milliseconds

period instead of colon inbetween seconds and milliseconds


--
soundengineer
------------------------------------------------------------------------
soundengineer's Profile: http://www.excelforum.com/member.php...o&userid=35904
View this thread: http://www.excelforum.com/showthread...hreadid=556950