Comparing 2 different time formats?

[mushin2003]

Hi I am having trouble comparing 2 columns each containing a time value.
The 1st column contains cells looking like this
A6: 9/1/2011 8:47:07 AM

the other column will have cells that look like this
D6: 847

I am working in VBA so would prefer to do this comparision in there but if it is easier to massage the cells prior to running my subroutine I will. I have taken cell A6 and split it into 2 cells which will look like
A6: 9/1/2011 B6: 8:47

Now I am unable to find a way to compare B6 to D6 having tried a few different ideas via cell formatting or converting values to "general" or numeric or pulling the data apart with text/left/right, etc. Also another idea that doesnt work is
B6 =Hour(A6)&MINUTE(A6) -> the result is 80

I am not sure it is relevant but the A6 field is formatted under Format Cells as "Time 13:30". The seconds are not needed.

Any help or ideas are appreciated.
Rob

[Bob Phillips]

Try this

=HOUR(MOD(A6,1))*100+MINUTE(MOD(A6,1))=D6

[snb]

=text(int(d6/100) & ":" & mod(d6;100),"hh:mm")=text(A6,"hh:mm") 

[mushin2003]

Thank you for your replies! both Bob and Snb's responses work