Formula for calculating Late Hrs & Early goings

Hi Guys, please help me to fix this out . Time sheet attached for your reference.

Tried with index & Match formula but it throws errors in few cases becoz Cell value are either stored in general or H:mm formats

For ex.

Cell value "05:07" has a custom format applied (hh:mm), and in the formula bar it is displayed as "05:07:00" which is not what we want. When I change the format to 'General' Excel converts the 'time' to decimal, eg "0.213194444444444".

When I manually enter 05:07 the problem is nearly resolved as it changes to 'general' without turning to decimal, but displays as 05:07:00. The formula converts it to decimal where it throws error.

Please help asap, as the deadline is hastily approaching..

Thanks