>Bernard,
>
>Convert the CHR fields to datetime. The dates can span days, if the elapsed time is more than 24 hours (>86400 seconds) then the trick with TTOC() needs some tweaking, you have to subtract off the number of whole days from the elapsed time first.
>
>>Actually both assumptions are wrong.
>>
>>The time is in a CHR field
>>The Dates could span days


Wish I could convert them but no such luck as the app is commercial and there are too many to update like so. Is it possible to maybe pop the time into a temp table with a datetime field, store DATETIME() to it and then do a replace with another date and time and then use your method?

Bernard