1363 Views 3 Replies Latest reply: Jan 18, 2009 5:17 AM by HeidiSAF
There may be a simpler solution, but this seems to work.
Enter the following in the cells named:
B2: 1:00 PM
B3: 1:01 PM
This will give you a number in B4 that is the fraction of a 24 hour day equivalent to 1 minute.
Put your base time ( 5:00 PM) in B5.
For the example, I wanted the schedule times in column E, starting at E7, and I used Column D to carry the increment in minutes from the base time.
Click the checkmark to confirm the formula, then drag the handle at the lower right of the cell to fill the formula down to as many rows as you need schedule items. (All cells should show 5:00 PM as you fill them.)
Enter 30 in D8 to change the time in E8 to 30 minutes after the base time, etc.
Note: While this worked for ADDING time to a base time, when I changed the + to a - the result cell displayed the base time no matter what value was in column D.
I would seriously suggest downloading and trying out version '09. It has a duration data type that works perfectly for this.
otherwise I would make one column Date/time with no date, only time shown. Then another column for the "number of minutes". Formatted to numbers. You would type in the number f minutes, 30, 45 90 etc... for the duration of that step. The start time for the next step is calculated.
See the below picture for what I did:
Hope this helps,
Message was edited by: jaxjason