J
Joey Mattingly
Hi! I am trying to make a scheduling template for work
and am running into some troubles. I have the formula to
calculate the hours worked, but need to modify it so that
if a person is scheduled more than 6 hours, it
automatically takes out a 30 minute break. Here is the
formula that I have:=IF((OR(B12="",B11="")),0,IF
((B12<B11),((B12-B11)*24)+24,(B12-B11)*24))
If it is also possible, I would like to be able to type
in the scheduled hours as being non-military time. Can
someone please help me? Please email me back at
(e-mail address removed). Thanks in advance.
and am running into some troubles. I have the formula to
calculate the hours worked, but need to modify it so that
if a person is scheduled more than 6 hours, it
automatically takes out a 30 minute break. Here is the
formula that I have:=IF((OR(B12="",B11="")),0,IF
((B12<B11),((B12-B11)*24)+24,(B12-B11)*24))
If it is also possible, I would like to be able to type
in the scheduled hours as being non-military time. Can
someone please help me? Please email me back at
(e-mail address removed). Thanks in advance.