NateW
11-06-2007, 02:31 PM
Hi, Folks.
Cell A1 = 11/6/2007
Cell B1 = 13:45:00
I need column C1 = 11/6/2007 13:45:00
I am using the "&" operator to merge the cells, but the formatting isn't coming across properly, giving me a weird value for the time.
Cell A1 is formatted as: *3/14/2001
Cell B1 is formatted as: h:mm
Cell C1 is formatted as: 3/14/01 13:30
Here is my code:
Sheets("gate Control").Cells(varMasterRow, 6).Value = _
Workbooks(varWorkbook).Sheets(varSheet).Cells(varRow, 1).Value & _
Workbooks(varWorkbook).Sheets(varSheet).Cells(varRow, 2).Value
If Cell A1 = 10/29/2007
and Cell B1 = 8:00:00 AM,
the result I'm getting for C1 = 10/29/20070.333333333333333
Can anyone help me get that to = 10/29/2007 8:00
?
Thanks in advance!!
Cell A1 = 11/6/2007
Cell B1 = 13:45:00
I need column C1 = 11/6/2007 13:45:00
I am using the "&" operator to merge the cells, but the formatting isn't coming across properly, giving me a weird value for the time.
Cell A1 is formatted as: *3/14/2001
Cell B1 is formatted as: h:mm
Cell C1 is formatted as: 3/14/01 13:30
Here is my code:
Sheets("gate Control").Cells(varMasterRow, 6).Value = _
Workbooks(varWorkbook).Sheets(varSheet).Cells(varRow, 1).Value & _
Workbooks(varWorkbook).Sheets(varSheet).Cells(varRow, 2).Value
If Cell A1 = 10/29/2007
and Cell B1 = 8:00:00 AM,
the result I'm getting for C1 = 10/29/20070.333333333333333
Can anyone help me get that to = 10/29/2007 8:00
?
Thanks in advance!!