Please correct me if I am wrong, but the arguments for DateAdd are DateAdd(datepart,number,date)
Say I am adding:
26:20:10 (26 hours,20mins,10sec)
+10:10:10 (10hours,10mins,10sec)
total: 36:30:10 (36hours,30mins,10sec)
Doesn't the DateAdd function use a 12 or 24 hour time base? The date part requirement could be used only for on part of the time I am adding, and the number parameter needs to be a whole number to add to the specified 'datepart'
So DateAdd("hh","mm","ss",26:20:10,10:10:10) or any variation thereof will not work.