| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Concatenate Custom Dates and Times
I have two columns with custom formats mmddyyyy and hhmm. I need to combine
them to create mmddyyyyhhmm. The file will ultimately be saved as a .csv |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Concatenate Custom Dates and Times
=a1+b1
and format as mmddyyyyhhmm (With dates in column A and times in column B) MadHydroSavant wrote: I have two columns with custom formats mmddyyyy and hhmm. I need to combine them to create mmddyyyyhhmm. The file will ultimately be saved as a .csv -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I calculate duration between two dates and times in excel? | Excel Discussion (Misc queries) | |||
| Multiple dates, times, or formulas in a single cell | Excel Discussion (Misc queries) | |||
| Count No. of times Dates are repeated | Excel Discussion (Misc queries) | |||
| Adding dates and times | Excel Discussion (Misc queries) | |||
| merge dates and times into one column? | Excel Discussion (Misc queries) | |||
Hybrid Mode
