Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel time conversion issue
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel time conversion issue
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. -- David Biddulph "benny" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel time conversion issue
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 "benny" wrote in message ... 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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel time conversion issue
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. "Peo Sjoblom" wrote: 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 "benny" wrote in message ... 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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel time conversion issue
Glad you've got a solution. We'd still be interested to hear what process
you went through which converted 0500 to 1123 previously? -- David Biddulph "benny" wrote in message ... 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. "Peo Sjoblom" wrote: 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 "benny" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
XML to Excel conversion issue | Excel Discussion (Misc queries) | |||
File conversion-text encoding issue | Excel Discussion (Misc queries) | |||
Vlookup text conversion issue | Excel Discussion (Misc queries) | |||
Date conversion issue... again | Excel Discussion (Misc queries) | |||
Date conversion issue "^" symbol | Excel Discussion (Misc queries) |