Thread: TIME FORMATING
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
shaji shaji is offline
external usenet poster
 
Posts: 28
Default TIME FORMATING

I am getting data from a party for usage some services. But the data I am
getting is not in time format. This is something like given below:

00.18.00.00
00.10.30.05
00.12.58.01
00.07.03.05
00.10.09.24
00.10.39.13
00.13.30.24
00.10.33.14
00.10.51.02
00.12.31.23
00.11.50.00
00.09.18.03

how I can convert this to time format ie. 00:00:00.00

thanks in advance.