Q: Cell formatting excel I need to display a time exceeding 24 hours, I write in a cell format in the Type [h]: mm; @ field and I get an answer not 25 hours, but 241: 00 who faced a similar problem, please help me to solve the problem.


A: As per the comment section; you are currently using CONCATENATE() to piece together integers (days) and fractions of those (time) into a string you weren't expecting, for example =CONCATENATE(C1,D1) results in =CONCATENATE(44385,0.868055....) which in return results in 443850.8..., hence the extreme results you were facing.
Instead just use: =(C1+D1)-(A1+B1)
