Thread: Change text (8:30 PM) to military time (20:30)
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
AFSSkier AFSSkier is offline
external usenet poster
  
Posts: 94
Default 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?

Reply With QuoteReply With Quote