If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I convert US date with 12hr format to European date 24hr
I am using Excel. I have a mix of 24hr and 12hr AM/PM format pulling from a
database. I want to reformat all dates with time to the 24hr clock so that I can then have 1 format to manipulate |
#2
|
|||
|
|||
How do I convert US date with 12hr format to European date 24hr
If the input data are formatted so that Excel recognises them as times, then
it doesn't matter whether they are 12 hour or 24 hour format. If you want to change them all to one format, use Format/ Cells/ Number/ Time, and choose to suit your preference. You may have problems if your data are treated as text because they have spare spaces or non-breaking spaces. In that case you'd have to change them to real times before formatting them. -- David Biddulph "Enda K" Enda wrote in message ... I am using Excel. I have a mix of 24hr and 12hr AM/PM format pulling from a database. I want to reformat all dates with time to the 24hr clock so that I can then have 1 format to manipulate |
Thread Tools | |
Display Modes | |
|
|