Time Diff

Please can someone tell me how to calculate the difference between two times stored in a recordset.
I do not need to calculate the difference in days or dates, i just need the difference in time.

[senthil]

Do you want the difference in Hours/Minutes/Seconds?

[senthil]

Use datediff function to find out the time difference

For Example:

'Difference in hours
diff = DateDiff("h", date1, date2)

'Difference in minutes
diff = DateDiff("n", date1, date2)

'Difference in Seconds
diff = DateDiff("s", date1, date2)