Change times to 24 hour and add 6 hours in strings
 

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!

Change times to 24 hour and add 6 hours in strings
 

What is it that you want to do exactly?

Pete

On Apr 11, 4:54*pm, rkd wrote:
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!

Change times to 24 hour and add 6 hours in strings
 

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 wrote:

What is it that you want to do exactly?

Pete

On Apr 11, 4:54�pm, rkd wrote:
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!

Change times to 24 hour and add 6 hours in strings
 

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

On Apr 12, 12:07Â*pm, rkd wrote:
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 wrote:
What is it that you want to do exactly?

Pete

On Apr 11, 4:54�pm, rkd wrote:
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!- Hide quoted text -

- Show quoted text -