Problem with sum working houers

Copper Contributor

I am trying to make automatic just to write start work h and end and automatic make else value (collum d and e) weekends i must delite formula because write #### and sum on bottom dont work. I think to write =SUMIF(D38-C44;"<0";0:00) and this dont work 

 

Second thing i wish to make if collum c-b is bigger than 8:00 write in collum d 8:00 and difference in collum e......

 

 

2 Replies

@CvijoVTI 

Does this do what you want?

@Hans Vogelaar 

 

Tnx for help. 

Your solution is better :) But I find one solution also make 3 more collum ac and ab and than hidden it and make if formula :) also work but my is lame :)