time difference

[learner1]

i had started my execution at Start_time = time
and it ended at End_time = time

now i want the differnec in hrs and mins that how much time it has taken to execute
like TotalTime =End_time -Start_time

can anybody send me the code for same

[learn_qa]

You can build a custom function using the built-in functions :- Hour, minute, Second.

[Saket]

you can use 'Timer' in your script.
e.g

Code:

StartTime = Timer ... Your Test statements ... EndTime = Timer msgbox EndTime-StartTime

[rdemers25]

The only problem with Timer is if you run overnight, it won't work right. because the timer is the seconds in the day and starts back at 0 at the beginning of the day.

[learner1]

It worked For me ; pls find the Code below :[/u]

Code:

Function Total_Execution_Time(Start_Time,End_Time) total number of seconds TotalTime_Secs = Datediff("s",Start_Time,End_Time) 'convert total Seconds into "Seconds only/ Mins+Secs/ Hrs+Mins+Secs" If TotalTime_Secs < 60 Then TotalTime = "Total Time Taken For Complete Execution = " & TotalTime_Secs & " Second(s) Approx." ElseIf TotalTime_Secs >=60 and TotalTime_Secs < 3600 Then TotalTime = "Total Time Taken For Complete Execution = " & int(TotalTime_Secs/60) & " Minute(s) and "& TotalTime_Secs Mod 60 & " Second(s) Approx." ElseIf TotalTime_Secs >= 3600 Then TotalTime = "Total Time Taken For Complete Execution = " & int(TotalTime_Secs/3600) & " Hour(s) , " & int((TotalTime_Secs Mod 3600)/60) & " Minute(s) and "& ((TotalTime_Secs Mod 3600 ) Mod 60) & " Second(s) Approx." End If 'Return the Message Total_Execution_Time = TotalTime End Function

[Saket]

Thats great learner1,

always put the formatted code here, use proper tags while posting.
This helps your posts making more readable.

[learner1]

Sure Saket
Next will take care!!