How would you do this manually, on paper? When you determine that, you can
do it in Excel using the same formula.

Tyro

"koob" <koob@koob wrote in message
...
Hi all

Is there a way to check the time in two cells to make sure that it doesn't
count a lunch break. ie

Start time is 8:45 end time is 16:25 so I need to subtract 30 minutes,
however if I run an if statement
and say use 12:30 if the job starts after 12:30 it will still subtract 30
minutes which I don't want.


Also If it ends before 12:00 again no time subtraction.

Thanks all