How to Create a Cutover Plan

belmer
ββ
Hi All,
I figured out how to create a cutover plan. Here is how to do it.
You need 4 columns:
- start time (text/number) - the first row you manually put in the time in military format. In the second row put in the following formula: =[End Time]1
- duration (text/number) - put in the number of mins the task will take
- end time (text/number) - put in this formula: =ROUNDDOWN(Minutes@row / 60) + ":" + RIGHT("0" + (Minutes@row - 60 * ROUNDDOWN(Minutes@row / 60)), 2)
- minutes (text/number) - this column will be hidden when you're ready to use the cutover plan. Type in the number of minutes so that End Time equals Start Time. In this example 1020 equals 17:00. So in row 1 put in the following formula: =1020 + [Duration (in mins)]1. In row 2 put in the following formula: =Minutes1 + [Duration (in mins)]2
You're all set. Just copy the formulas down, and as you put in the duration the End Time for the current row and Start Time for the following row will be automatically calculated.
Comments
-
Can you do this without using military format and using standard time format?
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.8K Get Help
- 474 Global Discussions
- 202 Use Cases
- 515 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 82 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives