Calculating over 24 hours

[tinselcat]

Hi
I cannot seem to get my spreadsheet to calculate over 24hours. I have tried the [h]:mm format but this is still showing values over 1000. I suspect it might be the calculations throwing it off but would be grateful if anyone can help me fix it. I have put a linlk to pictures of the spreadsheet with and without forumla view.

Thanks
https://drive.google.com/file/d/1nRhDsTDLncLg41c_kpzmU-JQIwb6IPY_/view?usp=sharing

 

[ParamRay]

Try formatting the all time columns as dd/mm/yyyy hh:mm:ss and check if, perhaps, one or more of the values include a date part in there by mistake.