I have a starting time in cell D8 which is 03:09 and finishing time in D9 which is 12:20 for a total of 9:11 hours.

I am trying to do a calculation in cell D10 that would say if the hours are equal to 8 or less then = to D9, if D9 is greater than 8 then I want 9:11 hours minus 8 hours then times the difference by 1.5 then add this to 8 hours.

This should then give a figure of 9:46 hours.

Hope this makes some sense.