Forum Discussion
Solved
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 corre...
Do the formulas in the attached file return the intended result?
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?