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)