how to calculate hours worked using 24hr clock

Evening everyone , I am looking for help with my attached sheet , I am struggling with the formula that will add up the hours overtime worked per day when I enter start and finish times

standard working hours are :
mon to thurs 8 hrs per day 8m to 16.30 (with 30 mins unpaid break)
Friday 6 hrs per day
Saturday all hours are overtime

Any help would be much appreciated

Regards
Matt

You have entered improper timing count. That the reason you are getting the error. Check the attachment

Hi Sathiskm , The column at the end that says o/t total for the day should say 1.50 hrs when the start time is 07:30 and finish time is 17:30, it currently says 10.00 so how do make it say 1.50?
thanks matt

I have managed to do it now using the formula =(C23-B23+(C23<B23))*24-8.5 cheers for your help

Use like this format