 ExcelExperts.comExcel Consultancy, VBA Consultancy, Training and Tips Call:+442081234832 |
|
Excel / VBA ConsultancyFree Training VideosFree SpreadsheetsExcel / VBA JobsNavigationWho's onlineThere are currently 0 users and 1045 guests online.
New Excel Experts
Current Excel / VBA Jobs |
Add year,month, day, hour and minHi Friends, I need an excel formula to add Year,month,day,hour,min which are placed in separate cell. The resultant date should be of format (dd/mm/yyyy HH:mm) and in a single cell.  |
Highest Ranked Users
Recent Blogs
ForumsRecent comments
User login |
You need to combine the
You need to combine the DATE() and TIME() functions - something like =DATE(a4,b4,c4)+TIME(d4,e4,0).
Chris