Here is what I have in cell A1 I have this number 22 which is convert from
another cell which is 10 pm and I have tried this =A1+9 but it only returns
22:00 and I have tried to format it different ways but I never get 31.

What I'm I doing wrong with this or is there another way to do this?