I have Some times ("hh:mm:ss") format in A column. In B column Have added a formula. It means i have added 8 hours based on A column data. B Column Formula : (=A2+time(8,0,0)).
A column time will not cross after 8 hours. If it will cross After * hours Column should be...