HI Friends,
Pl. give me the excel formula to add year,month,day,hour and min placed in seperate columns.
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
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