You need to enter times in this format
otherwise Excel will treat your entries as numbers. You should be able to use Edit>Replace to change all . to : then make sure all relevant cells are formatted as time.
If you have cells where the results of calculation will be greater than or equal to 24h then you need to select those cells and apply a custom format: