Time-Date problem

[Ethvia]

Hello all.

I am linked to a database and need to find the different between two dates in minutes. The problem is an interface feeds this information into the system in a way it makes it hard to capture a time difference.

I need to find the difference between point A and point B

TimeA: 03/16/2009 15:32
DateB: 03/16/2009
TimeB: 01/01/1999 16:03

So Point A is 03/16/2009 15:32, and Point B should be 03/16/2009 16:03. I'm assuming I need to write a 'formula' that joins DateB and TimeB but can't figure it out. I tried using Datepart to extract the minute and hour of TimeB but can't seem to join it with DateB to get the whole date/time in one column.

Is there an easier way to do this?

Thanks!

 

[CT Witter]

Are the second times always 01/01/1999 followed by time? Do you have ID's for each record?