Hello! My teams break charts generate each team members shift times in one cell. Exe: 7:30am - 1:30pm. I want to know if there is a formula or function to insert so that Excel can read the times in one cell, figure out the halfway point of that shift, and input that info into another cell.
Solved by V. A. in 25 mins