[QUOTE=protonLeah;2297008]for the sample provided:
CODE]=IF(B1+(12*(A1>B1))-A1>6,B1+(12*(A1>B1))-A1-0.5,B1+(12*(A1>B1))-A1)[/CODE]
where 12*(A1>B1) if the out time is less than the end time, then A1>B1 returns TRUE OR "1" else "0"[/QUOTE


This one worked great until there was a 12 hour shift I tried the >= but it did not work