| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date/Time concatenation
Hello,
Cell A1 = YR (YYYY) A2= Month (M) 1-12 no leading zero A3= Day (D) 1-31 no leading zero A4= Hour (H) 1-24 no leading zero How do I create a date/time (dd/mm/yyyy HH:MM) from these columns I know Date(a1,a2,a3) will gice me the date but how do I add the time as well? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date in Concatenation | Excel Discussion (Misc queries) | |||
| Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions | |||
| date and text concatenation | New Users to Excel | |||
| Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
| Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Threaded Mode
