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?
|