Posted to microsoft.public.excel.worksheet.functions

gobonniego

Posts: n/a

Change text to military time

I'm trying to change a column of 6 digit numbers into military time separated
by colons. Example 180333 to 18:03:33 (hours, minutes, seconds). I've used
=(A1/100)+(((A1/100)-(A1/100))/0.6) and reformat for time and also
=VALUE(LEFT(A1,LEN(A1)-2)&":"&RIGHT(A1,2))

Neither of them transfer the 6 digit number into the correct time. Any help?

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
How do I keep text viewing correctly as I change zoom %	Directionalman	Excel Discussion (Misc queries)	1	February 5th 06 03:32 PM
Change number format from text to number?	Scot	New Users to Excel	2	December 1st 05 04:15 PM
convert time imported as text to time format for calculations	batfish	Excel Worksheet Functions	3	October 27th 05 11:24 PM
Time Stamp without change	AntonyY	Excel Discussion (Misc queries)	3	November 26th 04 09:13 AM
Time Stamp-With Change	AntonyY	Excel Discussion (Misc queries)	1	November 25th 04 11:38 PM

All times are GMT +1. The time now is 03:22 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us