Excel has a timer function that I use to countdown the 30minutes before the race. It gives me regular timed downloads. Below is a sample of the code:-

With wks
ST = TimeSerial(Hour(Time), Minute(Time) + 0, 0)
t = .Range("C3").Value
ST1 = Hour(t - ST) * 60 + Minute(t - ST) 'establishes the time
'for the select case
If t > ST Then 'to prevent roll back after 1min download
Select Case ST1
Case 30 '30 minus a minute

Attached is a sample of what it produces.

Hope this helps.
Ta,
Martin

Attached Files

SampleSheet.xlsx (81.5 KB, 619 views)