Share via

work schedule break formula

Anonymous
2019-12-10T19:13:23+00:00

i am trying to add a formula to a work schedule to deduct .5 break from any day that meets or exceeds 6.5 hours

=(B5)=IF(6.5,1,0)+C5=IF(6.5,1,0)+F5=IF(6.5,1,0)+H5=IF(6.5,1,0)+J5=IF(6.5,1,0)+L5=IF(6.5,1,0)+N5=IF(6.5+P6,1,0)

is that possible ? what am I doing wrong ?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2019-12-10T20:59:43+00:00

    perfect!  thank you so much !!

    Was this answer helpful?

    0 comments
  2. HansV 462.6K Reputation points
    2019-12-10T20:48:57+00:00

    In Q4:

    =COUNTIF(B5:N5,">=6.5")

    Was this answer helpful?

    0 comments
  3. Anonymous
    2019-12-10T20:37:38+00:00

    thank you but that doesn't seem to work.  

    i am calculating hours by day, then the total hours per week, then where it says false i am trying to make a calcualtion that will add total breaks for week to subtract then last cell would be total hours less breaks

    any day that is 6.5 hours or more would have .5 break. so for example for ivan below where it says false, it should say 6

    <br>IVAN RAMOS <br>10:00 AM <br>9:30 PM <br> <br> <br>7:00 AM <br>9:00 PM <br>1:00 PM <br>10:00 PM <br>11:00 AM <br>10:00 PM <br>10:00 AM <br>10:00 PM <br>10:00 AM <br>8:00 PM <br>67.50 <br>FALSE <br>67.5
    <br>**** <br>11.50 <br> <br>0.00 <br> <br>14.00 <br> <br>9.00 <br> <br>11.00 <br> <br>12.00 <br> <br>10.00 <br>

    Was this answer helpful?

    0 comments
  4. HansV 462.6K Reputation points
    2019-12-10T19:55:03+00:00

    =B5-0.5*(B5>6.5)+C5-0.5*(C5>6.5)+F5-0.5*(F5>6.5)+H5-0.5*(H5>6.5)+J5-0.5*(J5>6.5)+L5-0.5*(L5>6.5)+P5-0.5*(P5>6.5)

    Was this answer helpful?

    0 comments