Difference in months and days between Timeline Milestones

Started by FlowerGirl, August 23, 2016, 06:11:14 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

FlowerGirl

Is it possible to create a smart connector or maybe some sort of Bracket Interval that could calculate the difference in "Finish" dates.
I attached a sample of what I am doing manually, but wondered if this could be done in Visio.

I calculate the differences externally in Excel before linking to Visio, would this help in any way...
I am assuming the connector would have to read the finish date upon gluing to the milestone shape.


Thanks for any help with this function.
FlowerGirl.

wapperdude

Here's a couple of variants.  Modified interval shape.  These show elapsed time in days.  This could be changed in the shapesheet / shapedata entry.

Wapperdude
Visio 2019 Pro

FlowerGirl

#2
Thanks so much for your response.
I changed the day count from days to month.days to 1 decimal point   :D
  using this formula  =FORMAT(Sheet.769!User.Duration/30.4,"0.0")*1

I will let you know shortly how it worked in my project.

FlowerGirl  :-*

Browser ID: smf (possibly_robot)
Templates: 4: index (default), Display (default), GenericControls (default), GenericControls (default).
Sub templates: 6: init, html_above, body_above, main, body_below, html_below.
Language files: 4: index+Modifications.english (default), Post.english (default), Editor.english (default), Drafts.english (default).
Style sheets: 4: index.css, attachments.css, jquery.sceditor.css, responsive.css.
Hooks called: 169 (show)
Files included: 32 - 1207KB. (show)
Memory used: 1033KB.
Tokens: post-login.
Cache hits: 13: 0.00203s for 26,544 bytes (show)
Cache misses: 3: (show)
Queries used: 16.

[Show Queries]