Thanks..
I think your idea is to store the elapsed time in a date variable(for eg: datetime field in database). Right ? And then add these datetime records to find the total.

If I want to use DATE variables, what are the things necessary to change in this code:
Code:
 lblElapsedTime.Caption = Format(DateAdd("s", DateDiff("s", Start_Time, Time), "0:0:0"), "hh:mm:ss")
Are these the only changes needed ?
Code:
Dim Start_Time As Date
Start_Time = Now

Private Sub Timer1_Timer()
    lblElapsedTime.Caption = Format(DateAdd("s", DateDiff("s", Start_Time, Now), "0:0:0"), "hh:mm:ss")
End Sub