Mar 31 2024 11:24 AM
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......
Mar 31 2024 12:13 PM
Does this do what you want?
Mar 31 2024 12:33 PM
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 🙂