H
Hoops
I am trying to adjust a formula to include more cells...I don't understand
the formula that well. It's for a employee work schedule. I've changed it
to go from hourly to every half hour. If there is text within certain cells
then it should equal a half hour of work for that employee. The formula
right now based on hourly is: =SUM(IF(ISTEXT(C6:K7),1,0)) The schedule goes
from 7am to 3pm (example c5 is 7am, then d5 is 8am and so on until 3pm) I
want to change: c5 to 9am, d5 to 9:30, e5 to 10:00 and so on all the way to
7pm. If there is any text within c6 and w6 (which would be 7pm) then I want
the formula to give me total hours worked.
the formula that well. It's for a employee work schedule. I've changed it
to go from hourly to every half hour. If there is text within certain cells
then it should equal a half hour of work for that employee. The formula
right now based on hourly is: =SUM(IF(ISTEXT(C6:K7),1,0)) The schedule goes
from 7am to 3pm (example c5 is 7am, then d5 is 8am and so on until 3pm) I
want to change: c5 to 9am, d5 to 9:30, e5 to 10:00 and so on all the way to
7pm. If there is any text within c6 and w6 (which would be 7pm) then I want
the formula to give me total hours worked.