trying to concat 2 cells in one DateTime value

**acheo** · 03-08-2016, 05:44 PM

Hi,

I have one cell that contain a date and one another that contain a time.

I'm simply trying to create a third one of the following format dd/mm/yy hh:mm. I have tried many thing in VB but none of them work.

Any idea?

thanks

acheo

**Crooza** · 03-08-2016, 05:50 PM

do you need to do in VBA?

date and time are simply numbers. I'm assuming your two cells are simply numbers and formatted as date and time only

if A1 is a whole number and A2 is a fraction only then

= A1 + A2 and format as dd/mm/yy hh:mm

**Crooza** · 03-08-2016, 06:09 PM

Oh and if the above is correct in regards to how your cells are formated then all you need for a macro would be something like this

Range("a3").Value = Range("a1").Value + Range("a2").Value

**acheo** · 03-08-2016, 06:25 PM

Yes VBA is required as I will export the data into a database. I just tried that code in VBA and it works. I knew it had to be simple :-)

thanks a lot!

acheo

**Crooza** · 03-08-2016, 06:41 PM

Great. Glad it worked. You should show the thread as being solved if this has addressed your issue

trying to concat 2 cells in one DateTime value

LinkBack

Thread Tools

Rate This Thread

Display

trying to concat 2 cells in one DateTime value

Re: trying to concat 2 cells in one DateTime value

Re: trying to concat 2 cells in one DateTime value

Re: trying to concat 2 cells in one DateTime value

Re: trying to concat 2 cells in one DateTime value

Thread Information

Users Browsing this Thread

Similar Threads

if statement for datetime value between two other datetime values

Invalid reference:when Gettin values in cells in another sheet (using Concat and Indirect)

Combine multiple cells in columns - Concat with variable spacing using VBA Script

[SOLVED] concat cells based on date range

Get data between two datetime cells

Based on a Column datetime value auto calculate and populate a datetime range

Subtracting datetime cells

Bookmarks

Bookmarks

Posting Permissions