Tweaking time calc

[HappyChappy]

Hi was wondering can anyone help
E=mround(c3,(1/24/60)*15)
F=mround(d3,(1/24/60)*15)
G=median("07:00","23:00",if(f3<e3,1+f3,f3))-median("07:00","23:00",e3)

this is for time worked on a shift to calculate wages, i would like to be able to take .45 min off of the calculation but only after 8.75 as min 8 hours before break is deducted.
can the current cell be modified or do I need to make a new calculation in a new cell to achieve this

Any help gratefully received

 

[Fluff]

Duplicate to: Break Entitlement

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.