Calculate time

[Excelexcel86]

Hi guys quick question how do I calculate time but only first 6 hours from two dates like so

02/03/2023 10:30 02/03/2023 15:30.

Obviously if I just minus the two cells I get 5 hours but I need it to stop calculating anything after 12:00 on the same day so it should be 1.30 hours

Any help be much appreciated

 

[awoohaw]

That’s just cell name for where the results go so when new dates get entered into the first 2 cells I can just drag these down with the formula created to calculate the results

how would you describe how they are calculated? I really don't understand the phrasing.
is it Time Worked (according to your desired formula) for the first column. I have no idea what the 2nd phrase means (maybe overtime?... if so are they any restrictions on how that is calculated?)

 

[Excelexcel86]

Hi it just means hours worked and yes call it overtime hours and no no restrictions

 

[Excelexcel86]

Hi anybody got any suggestions

Thanks for taking the time to look