Excel schedule

Last Edited By Krjb Donovan
Last Updated: Mar 05, 2014 09:33 PM GMT

Question

I am trying to figure out a formula that will allow me to add 30min, 10 min, 5min to a start time and then repeat for 2 days. Here is my example My start time is 8:00AM the next time I want to show up is 8:30 then 8:40 then 8:45 followed by 9:15 and then repeating the interval pattern.

Any help that you can provide would be greatly appreciated!


Jon

Answer

There are many different techniques inyou can use to break apart dates or times into their component parts, add or subtract dates, and figure out how much time is elapsed between two dates.

Read this free tutorial from my web site that explains how to work with adding dates and times in Excel:

http://599cd.com/tips/excel/adding-dates-times/?key=AllExperts

I also have this FREE video tutorial that shows you how to get month names (like "September") from dates:

http://599cd.com/tips/excel/month-names/?key=AllExperts

Advertisement

©2017 eLuminary LLC. All rights reserved.