subtracting a break from hours worked

Tech-Archive recommends: Fix windows errors by optimizing your registry



windows xp, excel 2003. i have never used any type of sprea*** before so am
needing help.
i have downloaded cpearson's time*** which was a great help for setting up
my time***. it works great but i'm having a problem deducting 0.5hr break,
this break does not have a start or finish time. i dont know where in the
formula to put the break.
the *** is set up like this:
start time finish time break total hours worked
13:00 22:00 0.5 8.5
the formula i am using is =(I2-H2+(I2<H2))*24
where do i put the break part of the formula.
any help would be most appriecated thanks
.


Quantcast