Time format only in cell [Excel] Solved

Question

Hello,

I currently have a small problem with Excel. Indeed, I am vainly trying to format a column of a table whose content is as follows: hhmmss. I would like to format this content in the following way: hh:mm:ss.
Unfortunately, when I manually format my cell with this format, Excel automatically adds the date before the time and the content of my cell is interpreted as a date (example 181134 ==> 04.12.2395 00:00:00).

How can I have ONLY the time in my cell?

Thank you in advance for your help.

Best regards

Gub

Configuration: Windows 7 / Firefox 20.0

mm936 · Accepted Answer

Hello,  check if this solution is valid:  In custom cell format====) enter the code: #" "00":"00":"00   A+

gbinforme · Answer

Hello,

If you enter example 181134, it will never be a time:
Excel takes it as a number, and your number represents the number of days between 1/1/1900 and ==> 04.12.2395, hence your display.

To have times, you must enter 18:11:34, which will be recorded as decimal hours in your cell; otherwise, they are days.
--
Always zen
Perfection is achieved, not when there is nothing more to add, but when there is nothing left to take away. Antoine de Saint-Exupéry

gub156 · Answer

Hi Mike-31,

Thank you for your response, but if I understand correctly, the brackets are only useful if my values can exceed 24 hours, right?
If that's the case, that's not my situation; my hours do not exceed 24 hours.

I've actually tried your solution, and Excel does not accept this cell format.

Thanks anyway for your help.

Gub

gub156 · Answer

Hello gbinforme,

Thank you for your response.
My problem is right there. The file I am working with is originally a txt file generated by an electronic device. Therefore, I cannot do anything with the txt file itself.
So I have to work with a hhmmss format. Is it simply not possible to obtain a cell in the hh:mm:ss format and not in the dd.mm.yyyy hh:mm:ss format?

Thank you in advance

Gub

gub156 · Answer

Thank you all for your help.  gbinforme, your solution actually works, thank you very much.   Have a nice day everyone.   Gub

Time format only in cell [Excel]

5 answers

Very slow computer

How to improve the speed of an iptv site on mobile?

How to configure hreflang for multiple countries?

Retrieve an email address

Phone alarm plus connected

Select text

Message saying that my phone is compromised

No sound on my laptop

Chronology

What does sata mean when it’s displayed on my hp laptop?