10
Vote Calendar Remaining Percent Completed / Progress Bar
Here is an Approach a Formula(s) for Calendar Remaining % Completed / Progress Bar
Percent of Calendar Meeting 1 Complete Formula:
({dtp}-{c1bp})/({c1ep}-{c1bp})100
if you want to round off the decimals, you can use
math.floor(number) + 0.5 (which rounds up/down to the nearest half point)
ie: to round the progress % above...
math.floor(({dtp}-{c1bp})/({c1ep}-{c1bp})*100) +0.5
Then, another formula is a Minutes Remaining Formula:
(({c1ep})({dtp}))(24*60) or rounded off... math.floor((({c1ep})({dtp}))*(24*60)) + 0.5
Published by Paul Hurst on 27 August 2015WatchMaker Tips & Tricks Posted