Home » Forums » Open Source Learning Center » Question and Answer

Add year,month, day, hour and min

Submitted by satish123 on 17 April, 2014 - 17:08

Hi 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.

Calc.jpg
‹ Excel 2007 Quick Access Toolbar Problem witn VBA Macros Translate ending stock quantity ›
»

You need to combine the

Submitted by chris on 18 April, 2014 - 17:00.

You need to combine the DATE() and TIME() functions - something like =DATE(a4,b4,c4)+TIME(d4,e4,0).

Chris

»