Please Help With Time And Date In One Cell

[rockyw]

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.

 

[mrmmickle1]

I used this trick on a workbook earlier this week. It will put in a date and timestamp based on when a value is entered into an adjacent cell. It may be worth looking at (Just be sure to change your iteration settings or it won't work):

Create A Timestamp In Excel With Formulas

You may also take a look at this:

Use a Calendar control or Date Picker to fill in dates

There is a lot of good info on Ron's Website! I find myself looking over the material on it regularly.