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
Try:
=DATE(A2,B2,C2)+INT(D2/24)+TIME(D2,E2,0)
copied down (format as TIME/DATE as desired).
Bookmarks