Add year,month,day,hours and min

[satish]

HI Friends,

Pl. give me the excel formula to add year,month,day,hour and min placed in seperate columns.

Year	Month	Date	Hour	Min	Result
1982	10	28	14	30
1	1	1	15	20
1983	11	30	5	50	30/11/1983 5:50

Note : if the hour exceeds 24, then the day should be increment by one and the remaining hour should be the resultant hour.

Thanks
Sat

[NBVC]

Try:

=DATE(A2,B2,C2)+INT(D2/24)+TIME(D2,E2,0)

copied down (format as TIME/DATE as desired).