Windows 7: Excel custom formula Help

Hi all,
I use microsoft excel 2012 and am quite familiar with how to use the software.....

I need a custom formula which will do the following :
Take a custom formula field (05/11/2012 08:59:07) its a custom field type but the only thing im interested in is the time .....

Then write a function which sorts all those that are after **:10:00 past the hour but before **:29:00 , and then again filter for **:40:00 and then before **:59:59 ... and place them in a column next to the field im sorting .
Ive tried an IF Statement but it does not work......

Could i consider conditional formatting and then highlighting the cells i want to key in on ...between the times

Thanks