Forum Discussion
Calculating and adding time
I am trying to figure out how to automatically calculate time differences for a delayed racing start time.
I have:
a rating which provides a handicap correction factor: PHRF Tod
A Sec/ Mile correction number
A Total correction in Seconds (based on a distance)
This I figured out.
I have a set start time for the first entry at 11:00:00
I need to figure out the Start time for the delayed boats as shown in the diagram, but I don't know what formulas will do this.
This diagram is taken from a pdf document.
Do the formulas in the attached file return the intended result?
5 Replies
Based upon OliverScheurich​ workbook but using 365 formulas.
delay = ROUND(distance*correction, 0) startTimeSec = 24*60*60*raceStart + delay# startTime = raceStart + delay#/(24*60*60) intervals = startTime# - DROP(VSTACK(raceStart, startTime#),-1) startNumber = SCAN(1, SIGN(intervals#), SUM)Hi Peter,
I am trying to use your formulas to make the list dynamic so I can add or remove rows without affecting the other numbers... I keep getting an error message with the delay# (it doesn't seem to like the hashtag where it is... )
any ideas?
Do the formulas in the attached file return the intended result?
Thanks Oliver.. yes, that helps...
Hi All, I have the problem sorted out.... Thanks anyway!
till next time...
