Replace multiple items

**richard_cook77** · 09-16-2014, 11:12 AM

Hi, I'm doing this spreadsheet which I've attached a screenshot of, as you can see it's a list of destinations, dates and times. I need to change all of the times to be 1 hour ahead of what they are now. Is there a quick way of doing this? Thanks

Screen Shot 2014-09-16 at 17.08.55.jpg

**daffodil11** · 09-16-2014, 11:27 AM

Go out into N2. Type =IF(D2="","",D2-1/24) and drag down. Copy N2:Nxx, Paste Values over D2:Dxx.

Repeat for F.

Replace multiple items

LinkBack

Thread Tools

Rate This Thread

Display

Replace multiple items

Re: Replace multiple items

Thread Information

Users Browsing this Thread

Similar Threads

Multiple items need find and replace at a time

How can I use replace(alt+H) for mutiple items needing replace

[SOLVED] How can I use replace(alt+H) for mutiple items needing replace

[SOLVED] How can I use replace(alt+H) for mutiple items needing replace

[SOLVED] How can I use replace(alt+H) for mutiple items needing replace

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions