I first deducted the laptime and actualstarttime of a race in a query using this formula and it gives me a correct lap1time value
Lap1Time:nz(Format([Lap1]-[Actualstarttime],"hh:nn:ss")) = 00:51:54
if i repeat this for lap2 to determine the lap2time value
Lap2Time: Nz(Format([Lap2]-[lap1],"hh:nn:ss")) = 00:00:03
and the 3rd lap = 00:00:03
It produces the correct time
My problem is adding up these to laptimes to get a totaltime from the start. I dont want to just deduct the finaltime after the 3rd lap from the actualstartingtime, as the number of laps may vary from race to race and i therefore prefer to add up the laps. My vb programming skills are lacking here.
i think the data type is string and it is formatted as hh:mm:ss - that is the problem.
TotalTime: Format([Lap1time]+[lap2time]+[lap3time],"hh:nn:ss")
lap1time = 00:51:54 ; lap2time= 00:00:03 ;
lap3time=00:00:03
then i get = 00:51:5400:00:0300:00:03 which is a combination of lap1time+lap2time+lap3time rather than adding it up and giving you = 00:52:00
i think the data type is string and it is formatted as hh:mm:ss - that is the problem.
anybody out there that can relieve me of this unnecessary stress in my life by providing a solution? hehehe