I have a worksheet table that has a one "1" in each cell during the hour where an employee is at work. I am trying to calculate each employees start and stop time, which are represented by the first "1" in each row and the last "1" in each row respectively. The sample file (attached) should be clear and includes the expected results (cells B5:C7).
What formula would go in cells B5 and C5 (to then be dragged down)?
Thanks,
D
Bookmarks