+ Reply to Thread
Results 1 to 3 of 3

Scheduling changes by increments of time within a cell

  1. #1
    Registered User
    Join Date
    08-29-2018
    Location
    New York, NY
    MS-Off Ver
    Office 2016
    Posts
    11

    Question Scheduling changes by increments of time within a cell

    Hello!

    I write schedules for work, and I want to know how to push a schedule to start later (or pull one up to start earlier) without having to manually change each block of time. IMPORTANT: Time blocks must be within the same cell under the following format: "10:30am-11:00am", the two times cannot be in separate cells.

    Basically, I want to know what the solve is if I write a whole schedule to start at 10:30am and then decide I want it to start at 11:00am instead. How do I avoid having to manually retype all the blocks of time?

    Thanks in advance!

  2. #2
    Registered User
    Join Date
    08-29-2018
    Location
    California
    MS-Off Ver
    Office 365
    Posts
    12

    Re: Scheduling changes by increments of time within a cell

    check out the attached. I believe this will help with your situation.

    With this solution, you only need to change the first value on the Time Range tab and the rest will change accordingly.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    08-29-2018
    Location
    New York, NY
    MS-Off Ver
    Office 2016
    Posts
    11

    Re: Scheduling changes by increments of time within a cell

    Thank you so much, this was very helpful!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Looking for formula to copy down that increments the cell reference 5 rows each time
    By Cbird in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-24-2018, 02:16 PM
  2. Scheduling: Calendar style scheduling based on scheduling list
    By denkatprieto in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 12-19-2012, 11:10 AM
  3. [SOLVED] Add Time Increments to Plot
    By WolfpackAttack in forum Excel General
    Replies: 7
    Last Post: 09-19-2012, 07:26 PM
  4. [SOLVED] Rounding Time into 30 min increments
    By Icehockey44 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-08-2012, 07:52 AM
  5. Time Increments
    By Andrew C in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-09-2006, 08:45 PM
  6. Time increments
    By Ntisch in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 09-29-2005, 02:00 AM
  7. How do I add time when some of the increments are less than an ho
    By Learning Center Student in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 05-18-2005, 02:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1