Combining Time with Date

Hi all,

Suppose i have two columns A & B.
Column A has Date Values in the Format 10-Feb-08
while Column B has Time Value in the Format 4:11 PM

I have a third column C which has current date in the format. i.e. 13-Feb-08 7:35 PM.


Now:

actually i have to calculate the exact difference between the date+time (column A&B) and current date.

i.e. i want to calculate number of days or number of hours between column A (with column B joined to it)

and current date.

IN SHORT

i want to merge Column B to Column A to represent a complete date in the format ( 10-02-2008 04:11:00 PM )




how ?

the person who replies with may please also send me email to khalidmehmoodawan@gmail.com