booleanboolean
New Member
- Joined
- Feb 25, 2017
- Messages
- 37
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?
<colgroup><col span="2"><col><col span="4"></colgroup><tbody>
</tbody>
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>