Change times to 24 hour and add 6 hours in strings

[rkd]

Hi

Is there a handy way of doing the above to strings in cells like this?

Su Open 3:00p M-FR 5:00p-4:00p


Much appreciated!

 

[Pete_UK]

What is it that you want to do exactly?

Pete

 

[rkd]

Take strings with times in them and update them to 24hour format and
add 6 hours to change from CST to GMT.

Example strings:
Su Open 3:00p M-FR 5:00p-4:00p = Su Open 21:00 M-FR
23:00-22:00
M-FR 11:00a-4:00p = M-FR 17:00-22:00

 

[Pete_UK]

If you only have a few varieties of string, then perhaps Edit |
Replace (CTRL-H) a few times might be appropriate:

Find what: 5:00p-4:00p
Replace with: 23:00-22:00
Replace All

CTRL-H again:
Find what: 11:00a-4:00p
Replace with: 17:00-22:00
Replace All

CTRL-H again:
Find what: 3:00p
Replace with: 21:00
Replace All

and so on.

Hope this helps.

Pete