Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time Cells
I have a data dump that depicts 7:00 am as "700" and 5:00 pm as "500" (both
numbers.) I need to convert them to military time. Is there an easy way to do this? When I try formatting the cells as time they all change to "00:00" as excel attemps to convert the number into a date & time. Any guidance is appreciated. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formatting cells for time | Excel Discussion (Misc queries) | |||
formatting cells for time | Excel Discussion (Misc queries) | |||
Elapsed time when separate cells contain time and separate date | New Users to Excel | |||
How to chnge 35 relative cells to 35 absolute cells at one time. | Excel Worksheet Functions | |||
add time to cells | Excel Worksheet Functions |