Joey,
How about
=IF(MAX((B12-B11),(B11-B12))TIME(6,0,0),MAX((B12-B11),(B11-B12))-TIME(0,30,
0),MAX((B12-B11),(B11-B12)))
If you want to enter time non-military, you need to append AM or PM , like 8
AM or 7:15 AM (note the space)
--
HTH
-------
Bob Phillips
... looking out across Poole Harbour to the Purbecks
"Joey Mattingly" wrote in message
...
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
. Thanks in advance.