Prevent Clng from dropping Time off returned Serial value

[bdb1974]

I'm really struggling with this.

In a cell I have a date in the format as : 3/23/2012 10:22AM

I would like to compare this to another date and time so I'm thinking I need to convert it to a serial number.

I'm trying to use Clng to convert the date w/time , to a decimal numerical value. However, everything to the right of the decimal is being dropped off, thus removin the time(fraction) part of the value.
IE: Instead of returning someting like 40877.52457, I'm getting 40877 returned.

Dt = "3/23/2012 10:22 AM"
Dt = Clng(Dt)

Any help is appreciated.

Thanks,

BDB