Add year,month, day, hour and min

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.


You need to combine the

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