Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting Standard Time into Military Time
I have a column of standard times (example 6:50pm) that need to be converted
to military times (example 18:50); is there a formula or formatting feature that can convert the entire column? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting Standard Time into Military Time
Excel maintains time as fractions of a 24 hour day. Whether you see the time
as 6:50pm or 18:50 depends on how your format the time. Tyro "mtvschultz" wrote in message ... I have a column of standard times (example 6:50pm) that need to be converted to military times (example 18:50); is there a formula or formatting feature that can convert the entire column? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting Standard Time into Military Time
If they are properly formatted times simply select the column and then
Format|Cells select Custom and use hh:mm Mike "mtvschultz" wrote: I have a column of standard times (example 6:50pm) that need to be converted to military times (example 18:50); is there a formula or formatting feature that can convert the entire column? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting Standard Time into Military Time
7 minutes after your first post?
Have a little patience. You can format the entire column by selecting it and formatcellsnumbertime Gord Dibben MS Excel MVP On Fri, 15 Feb 2008 10:37:02 -0800, mtvschultz wrote: I have a column of standard times (example 6:50pm) that need to be converted to military times (example 18:50); is there a formula or formatting feature that can convert the entire column? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting Standard Time to Military Time in Excel | Excel Discussion (Misc queries) | |||
converting military time | Excel Worksheet Functions | |||
How to I convert standard time to Military or 24 hour format? | Excel Discussion (Misc queries) | |||
Converting decimal time to standard time? | Excel Discussion (Misc queries) | |||
Convert data into standard military time format | Excel Discussion (Misc queries) |