Change times to 24 hour and add 6 hours in strings

  • Thread starter Thread starter rkd
  • Start date Start date
R

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!
 
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
 
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
 
Back
Top