subtracting time values

[bertieuk]

I am have a few problems trying to subtract two date values that hold time. I am after the difference

The values start of in the format #6:52:11 AM#

When I take away #6:51:18 AM# from #6:52:11 AM#, I get 6.13425925925892E-04 (double value). If I try to convert it back to a time (It should be 53 Second), I get #12:00:53# using CDate. I get nothing using Time or Timevalue. Can anyone help point me at the right function.

Thank
Si

 

[PHV]

And what about the DateDiff function ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886