How do I convert time in multiple cells to military format?

[booleanboolean]

I am afraid I am going to have to do this manually. For all of the times you see below except for those cells which say "OFF", I will have to convert to military time in this format: 0600-1400, so on and so forth.

Is there any way this can be accomplished?

F	Sa	Su	M	T	W	T
OFF	OFF	6a-2p	6a-2p	6a-2p	6a-2p	6a-2p
6a-2p	6a-2p	OFF	OFF	6a-2p	6a-2p	6a-2p
6a-2p	6a-2p	OFF	OFF	6a-2p	6a-2p	6a-2p
6a-2p	6a-2p	OFF	OFF	6a-2p	6a-2p	6a-2p
7a-3p	7a-3p	OFF	OFF	7a-3p	7a-3p	7a-3p
6a-2p	6a-2p	6a-2p	6a-2p	OFF	OFF	6a-2p
12a-8a	12a-8a	12a-8a	OFF	OFF	12a-8a	12a-8a
6a-2p	6a-2p	6a-2p	6a-2p	6a-2p	OFF	OFF
OFF	8a-4p	8a-4p	8a-4p	8a-4p	8a-4p	OFF
OFF	OFF	6a-2p	6a-2p	6a-2p	6a-2p	6a-2p
OFF	6a-2p	6a-2p	6a-2p	6a-2p	6a-2p	OFF
8a-4p	8a-4p	8a-4p	8a-4p	OFF	OFF	8a-4p
6a-2p	6a-2p	6a-2p	6a-2p	6a-2p	OFF	OFF
OFF	12a-8a	12a-8a	12a-8a	12a-8a	12a-8a	OFF

<colgroup><col span="2"><col><col span="4"></colgroup><tbody>
</tbody>

 

[James006]

Hello,

Go to Custom Format ... and add 00\:00

HTH

 

[Rick Rothstein]

Are your time spans always exactly 8 hours as your example table shows, or is your example a simplification of what your data really looks like?