| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How to Join/concatenate a date field with a time field in Excel?
I have another application that exports to Excel where column A has the
date and column B has the time. I want to be able to combine the two fields in a 3rd field, say column C, where the time reads like it does when you enter in the command =now(). The date format is correct, but the time comes in text format, not time format.Can anyone help me with a formula that combines the 2 cells to create a correct Excel formatted date & time cell?? TIA, Alan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Choice of Date or another field | Excel Discussion (Misc queries) | |||
| Convert date to length of time in months from set date | Excel Worksheet Functions | |||
| Time "and" Date for data points | Charts and Charting in Excel | |||
| US vs UK date and time formats | Excel Discussion (Misc queries) | |||
| Help wtih date and time in the same cell | Excel Worksheet Functions | |||
Threaded Mode
