How do I get Excel to combine the two fields shown, so that, for example, "3:45:33 PM" appears? Nothing works. I have column D formatted for 'time', and it still comes out a mess of decimals..... You'd think this would be easy, but it doesn't seem to be. I'm using Office 2007.