Change text to military time

G

Guest

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

military time set up 6
Adding/Subtracting military time 0
Change a 1,2,3 or 4 digit number to a 6 character text string 3
How do I convert dollars and cents to text, and prefill the cell . 1
Difference between 2 dates&time(format 0000), and excludes weekend 1
macro to change text to time 1
convert time imported as text to time format for calculations 3
Time Calculations Help 4

Top