Solved

combined data and time in a single cell

Posted on 2011-03-16
2
243 Views
Last Modified: 2012-05-11
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.
0
Comment
Question by:MikeORTEC
2 Comments
 
LVL 85

Accepted Solution

by:
Rory Archibald earned 500 total points
ID: 35148281
=A50+C53
and format as dd-mmm-yy hh:mm
0
 

Author Closing Comment

by:MikeORTEC
ID: 35148301
Perfect.
0

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question