Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
E6 = Finish Time.
B6 = Start Time.
My working formula: =E6-B6+(E6<B6) =Time worked in Hours/Minutes
How should I modify my formula to "minus 1 Hour" for a break?
Sounds easy, but I can't get this to work.
Any help, please?
append -1/24 (1 hour for a total of 24 hours per day)
=E6-B6+(E6 < B6)-1/24
Required, but never shown