Overtime hours before 8am and after 5pm

Would someone be kind enough to show me how to correctly write this formula to show hours worked before 8am + hours worked after 5pm

=IF(D6>=0.333333333,0,if(D6-.333333333*24(E6<=0.708333,0, if(E6-0.708333*24))))

D6 is start time and E6 is finish time. Cell m6 hold this formula. My first formula (E6<=0.708333,0, if(E6-0.708333*24 was working fine calculating hours worked after 5pm, then i realized it was not calculating hours before 8am as overtime.

Originally Posted by mikelm

would someone be kind enough to show me how to correctly write this formula to show hours worked before 8am + hours worked after 5pm

=if(d6>=0.333333333,0,if(d6-.333333333*24(e6<=0.708333,0, if(e6-0.708333*24))))

d6 is start time and e6 is finish time. Cell m6 hold this formula. My first formula (e6<=0.708333,0, if(e6-0.708333*24 was working fine calculating hours worked after 5pm, then i realized it was not calculating hours before 8am as overtime.

Please Login or Register  to view this content.

m6=if(e6-if(d6<1/3,1/3,d6)>9/24,e6-if(d6<1/3,1/3,d6)-9/24,0)

works for above 5pm, but not below 8am. What's the complete code?