combined data and time in a single cell

Cell A50 contains the date in the format 15-Mar-2011
Cell C53 contains the time as 11:11

I would like to write a formula in cell H54 that combines these values to read:

15-Mar-11 11:11

I want to be able to use the combined value for calculations later so it cant just be text.

I know I have done this before, but cannot remember how to combine the date and time like this.
MikeORTECAsked:
Who is Participating?
 
Rory ArchibaldConnect With a Mentor Commented:
=A50+C53
and format as dd-mmm-yy hh:mm
0
 
MikeORTECAuthor Commented:
Perfect.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.