I would like to add a date and time picker in a workbook. I can make a date and a time picker separate but then I need to bring both into one cell. I need a format like 7/28/14 18:00. Every formula I try gives me 7/28/14 18, Is there anything that works? I have 2007 at home and 2010 at work, both do not work as I would like. I would love both date and time together but will be happy with a formula to bring both into one cell. Thanks for any help.