| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change text (8:30 PM) to military time (20:30)
I'm trying to change times that are reported in text format (ie 8:30 PM
instead of 8:30PM) into military time equivalents (20:30). Is there a straightforward way to do this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Change text (8:30 PM) to military time (20:30)
Take a look under the "time" formats. Format--Cells---Number tab---Time
The first one should do the trick. There are also options in the "custom" formats as well. Dan "Netorius77" wrote: I'm trying to change times that are reported in text format (ie 8:30 PM instead of 8:30PM) into military time equivalents (20:30). Is there a straightforward way to do this? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Change text (8:30 PM) to military time (20:30)
Format, Cell, Number, Time - 13:30:55
or Custom Format it to HH:MM -- I hope this helps, Kevin "Netorius77" wrote: I'm trying to change times that are reported in text format (ie 8:30 PM instead of 8:30PM) into military time equivalents (20:30). Is there a straightforward way to do this? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Change text (8:30 PM) to military time (20:30)
Thanks for the above. I had tried to reformat the cells, but now find that
there are actually three spaces after each entry. Removing these spaces resolved the problem of being unable to format. Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can you change the Text Import Wizard column options | Excel Discussion (Misc queries) | |||
| How change dimensions of data label text box in pie chart? | Charts and Charting in Excel | |||
| Change number format from text to number? | New Users to Excel | |||
| Change number in Text Box in Excel | Excel Discussion (Misc queries) | |||
| Time Stamp without change | Excel Discussion (Misc queries) | |||
Linear Mode
