Calculate time difference

[zubairkhan]

Dear friends

I want to calculate difference b/w two times:

Thanks

[Pino]

Dear friends

I want to calculate difference b/w two times:

Thanks

Please where possible allways search the forums

This should help you out,
http://www.vbforums.com/showthread.p...light=datediff

If not post back

[westconn1]

use the DateDiff function

elapsedminutes =DateDiff("n",time1,time2)

rgds pete

[zubairkhan]

with datediff function the output comes on the basis of 10 base
suppose i have first time is 9:55 and second time is 8:15, datediff function returns 620 , divide it by 60 = 10.33, which is wrong ansower should be 10:40

[westconn1]

with datediff function the output comes on the basis of 10 base
suppose i have first time is 9:55 and second time is 8:15, datediff function returns 620 , divide it by 60 = 10.33, which is wrong ansower should be 10:40

of course it is the correct answer for what you did. the answer is actually 10 hrs 20 mins,

the calculation to get this is:-

dd = DateDiff("n", "9:55", "20:15")
dd = dd \ 60 & ":" & dd Mod 60

rgds pete