Posted to microsoft.public.excel.misc

shaji

external usenet poster

Posts: 28

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Hot key for time?	Dave in Des Moines	New Users to Excel	2	March 24th 06 04:31 PM
Hot key for time?	Dave in Des Moines	Excel Worksheet Functions	2	March 24th 06 04:15 PM
Hot key for time?	Dave in Des Moines	Excel Discussion (Misc queries)	1	March 24th 06 03:46 PM
time sheet to calculate 2 different columns	John Sullivan	Excel Worksheet Functions	1	October 21st 05 06:48 AM
formating military time	LHaro	Excel Discussion (Misc queries)	2	June 28th 05 07:46 PM

All times are GMT +1. The time now is 04:30 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us