Excel time conversion issue

[Guest]

I imported some data into excel. Time values were in military format but
when moved to excel the values change. Tried to convert back to military
time using format cells but this does not work. For example, 0500 changed to
something like 1123 in excel.

 

[David Biddulph]

I think we'll need a bit more detail. What sort of file did you import into
Excel? How did you import it? What did you do with the 0500 to get it to
change to 1123?
Remember that times in Excel are formatted with a semi-colon, so they ought
to be put in as 05:00, for example. If it was starting as 0500 there are
ways of translating to time, but we need to know. Merely changing the
format doesn't change the values in the cells, of course.

 

[Peo Sjoblom]

Don't assume everyone knows what you mean by "military format" Some call
24:00 military format other call 2400 military format, it looks like you
mean the latter. I can't see how 0500 can change to 1123. How do you import
the data?
If you want to convert 500 to 5:00 you can use


=--TEXT(H1,"00\:00")

and format as time, but I find it hard to see how 500 became 1123 just by
importing it


--


Regards,


Peo Sjoblom

 

[Guest]

Sorry I'm a new poster and wasn't specific enough. Excel was importing the
dates in as text. Your formula worked and then I formatted to the military
format that I wanted. Thanks so much.

 

[David Biddulph]

Glad you've got a solution. We'd still be interested to hear what process
you went through which converted 0500 to 1123 previously?