**I need help, I am doing a time sheet that contains shift work and allowances and lunch times that vary.**

The formula I have which allows me to manually input the break times is :

*Start time***D6***Breaks***E6**.... needs to be manually entered as it can vary from 30min to 1.5 hours*Finish time***F6**

=ROUND((IF(OR($D$6="",$F$6=""),0,IF($F$6<$D$6,$F$6+1-$D$6,$F$6-$D$6))-$E$6/1440)/(1/1440),0)*(1/1440) this works fine,

but then I have a formula for shift allowance

=(F6<D6)*("21:30"-"14:30")+MEDIAN(F6,"14:30","21:30")-MEDIAN(D6,"14:30","21:30")

which adds up fine too but I need to add a formula for (breaks) **E6** to the shift allowance formula

are there any solutions.... please