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


soundengineer wrote:
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


Hi soundengineer

If you've got a "real" time, try

FormatCells Category: Custom Type hh:mm:ss.000

Regards

Steve